Help with formulas

poesiecat · May 24th, 2002, 08:28 AM

Question....why would a formula suddenly not work across workbooks? I have a workbook where the cell's value is another workbook's cell value*1.1 I put in that formula, and wanted the entire column underneath to follow suit, so I did a copy/paste function, and instead of moving through the 2 workbooks, it kept using the same formula over and over again. I have NEVER had a problem like this before...it has always worked.. Any ideas?

Frustrated.

sann0638 · May 24th, 2002, 08:30 AM

It sounds like you need to unlock the formula by removing the dollar signs. These are automatically put in when linking between books - anyone know why this is?

May 24th, 2002, 08:30 AM	#2
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	It sounds like you need to unlock the formula by removing the dollar signs. These are automatically put in when linking between books - anyone know why this is? __________________ Regards, Mike.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 08:28 AM	#1
poesiecat New Member Join Date: May 2002 Posts: 1	Question....why would a formula suddenly not work across workbooks? I have a workbook where the cell's value is another workbook's cell value*1.1 I put in that formula, and wanted the entire column underneath to follow suit, so I did a copy/paste function, and instead of moving through the 2 workbooks, it kept using the same formula over and over again. I have NEVER had a problem like this before...it has always worked.. Any ideas? Frustrated.