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
|
|||
|
|||
#REF error on linked spreadsheet
I am trying to help a client that has 6 spreadsheets that are linked. If he
opens the main sheet and clicks update to update the links, he has several columns with the #REF in it. That cell is referencing another spreadsheet. However when I open that spreadsheet and click update to update it's links the #REF changes to the proper values. I have checked the status on all links and saved and closed them. Then I reopened that main spreadsheet and got the #REF again. Can anyone steer me in the right direction to fix this? He's on Win and Excel XP and said it didn't used to do that. Thanks, Carla |
#2
|
|||
|
|||
Hi Carla,
Is it possible the spreadsheet doesn't automatically calculate? Some of the sheets may be set to calculate manually. To check, go to the Tools menu, click Options, and then click the Calculation tab. Under Calculation, select an option. Changing this option affects all open workbooks. If you select an option other than Automatic, press F9 to calculate all worksheets in all open workbooks. To calculate only the active worksheet, press SHIFT+F9. It may just be one more thing to check in your quest for an answer. Regards, Randy "Carla Bradley" wrote: I am trying to help a client that has 6 spreadsheets that are linked. If he opens the main sheet and clicks update to update the links, he has several columns with the #REF in it. That cell is referencing another spreadsheet. However when I open that spreadsheet and click update to update it's links the #REF changes to the proper values. I have checked the status on all links and saved and closed them. Then I reopened that main spreadsheet and got the #REF again. Can anyone steer me in the right direction to fix this? He's on Win and Excel XP and said it didn't used to do that. Thanks, Carla |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
error with linked tables manager | Wendy G | Database Design | 16 | November 2nd, 2004 10:36 PM |
Linked spreadsheet locks other files out | John Taylor | Setting up and Configuration | 1 | March 11th, 2004 06:28 PM |
outlook contacts linked to excel spreadsheet? | Doug | Worksheet Functions | 0 | February 20th, 2004 11:54 PM |
Show the product of a formula calculated in spreadsheet one in spreadsheet 2 | Ronnie | Worksheet Functions | 1 | December 5th, 2003 02:20 AM |
multi-user lockout of linked excel spreadsheet | Tim Schiermeyer | Setting up and Configuration | 0 | November 15th, 2003 01:56 AM |