Hardware

Hello,

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.