Linked Cells??

Posted by Rob on July 23, 2001 3:33 PM

OK, I have a sheet which has links to dynamic named ranges in another sheet (thanks to aladin). The problem is, when I open the sheet with the links, I get errors. When it asks if I would like to update the linked information, I click yes, the message comes up "Microsoft Excel cannot find 'Fees' on 'Fundings 2001.xls'." I have made sure the links are correct (the full file path is in the links). BUT, I noticed if I open up the page with that data first, then the page with the linked cells updates just fine. Is there a way to fix this so I don't have to open the data file first?

Thanks

Posted by Mark W. on July 23, 2001 4:08 PM

Open the workbooks in an order based on dependency.
Next, use the File | Save Workspace... menu command to
create a workspace (.xlw). Now open the workbooks
using the workspace and the associated workbooks
will always be opened in the correct order.