|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 16th, 2010, 09:06 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
updating Data links
I have two spreadsheets A and B both with multiple tabs. Spreadsheet B in
linked to Spreadsheet A. I changed the name of one of the tabs in spreadsheet A with out having B open. When i opened up B I notice a ton of "#REF" symbols. This is because the tabs name that it is looking for is no longer availible. Is there a way to update this has a whole instead of having to link all 500 cells individually. 
|
|
#2
April 17th, 2010, 12:24 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
updating Data links
Have you tried simply opening workbook A and giving that renamed tab its old
name back, and then opening Workbook B. Then with both open, again change the tab name in A and see if that doesn't clear matters up for you. "Todd" wrote: I have two spreadsheets A and B both with multiple tabs. Spreadsheet B in linked to Spreadsheet A. I changed the name of one of the tabs in spreadsheet A with out having B open. When i opened up B I notice a ton of "#REF" symbols. This is because the tabs name that it is looking for is no longer availible. Is there a way to update this has a whole instead of having to link all 500 cells individually.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
