Question
Thread display: Collapse - |
All Answers
Share your knowledge
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Linked Worksheet Formula Not the Same for All Users
I need some help with Excel 2010 linked workbooks.
The Accounting department has an Excel workbook that has multiple worksheets and is saved to a shared drive. On these worksheets there are links to other workbooks and worksheets, saved to the same shared drive. When one user opens the file, the path to the linked workbooks and worksheets is correct for all of the worksheets in the file. However, when other users open the same file, the path to the linked workbooks and worksheest is correct except for one worksheet. On that particular worksheet, the path looks to the C drive for the file, instead of the shared drive.
Any clue what could be causing this problem? How do we fix? How do we prevent this from happening in the future?
Any help will be greatly appreciated.