links ??????????

[coltheplumb]

Hi all im having a slight problem i have several worksheets in various workbooks that have links between the different worksheets, i have just renamed the tabs of all the worksheets (from 2010 to 2011) but now the links dont recognise the sheets where the original info came from any ideas
Thanks for any help

Colin X

 

[jmthompson]

Find (Ctrl F)
"2010"
look in Formulas
Replace with
"2011"

 

[coltheplumb]

Na that did not work , i have however noticed an error msg that says...moving or deleting cells caused an invalid cell reference... ? but all i changed was the sheet tab names ? any other ideas

Colin X

 

[coltheplumb]

Any ideas on this one ? i was under the impression that if all tab names were change then excel would automatically recognise the new names

All help appriciated

Cheers

Colin X

 

[xenou]

It is usually necessary to have all the workbooks open if you want Excel to "keep up" with the changes automatically - in fact, make sure all the workbooks are open any time any structural changes are made (adding rows, deleting columns, changing tabs or file names).

 

[coltheplumb]

ok xenou i will give that a go and remember that info

thanks again

Colin X