Home » Any Answers » Linked spreadsheets in Excel 2007

Linked spreadsheets in Excel 2007

Posted by JKnight PM | on Thu, 20/05/2010 - 13:10  1717  6 comments | report

Hi, can anyone help me with this problem...

I have two spreadsheets: a summary spreadsheet 'A' and a workings spreadsheet 'B' that contains quarterly figures. 'A' contains formulas linking to values in 'B'. If I save 'B' as 'C' in order to do workings for the next quarter Excel helpfully updates the linked formulas in 'A' to look to the new spreadsheet 'C'.

Is there a way to stop Excel 2007 doing this automatically?

My spreadsheets were created in Excel 2000 and we have recently upgraded to Excel 2007. I didn't have this problem with the Links changing in the old Excel.

 

 

 

Comments
There are 6 comments. Login or register to view them.

Options/Advanced

gsgordon | Thu, 20/05/2010 - 14:13

Still doing it

JKnight | Thu, 20/05/2010 - 15:24

Close the 'destination' file

patvanaalst | Thu, 20/05/2010 - 16:08
patvanaalst's picture

Yes - it still works

paulwakefield1 | Thu, 20/05/2010 - 17:17

Sorted

JKnight | Thu, 20/05/2010 - 17:35

Separate spreadsheets?

cfield | Sat, 22/05/2010 - 11:44
cfield's picture