Linked Spreadsheets

[Mike Lang]

Hi, I have a spreadsheet which is getting large and unweildy. Because a lot
of the standard data is stored in a Data worksheet, I copied it out to
another spreadsheet.

My problem is that for my master sheet to be able to find the data on the
Data sheet, the data sheet needs to be open as well. Is there anye asy way
of either making my master sheet retrieve the data from the data sheet when
it ISN'T open OR to automatically open the data sheet when I open the master
sheet?

Thanks

Mike

 

[Jacob Skaria]

Hi Mike

Open all linked workbooks.
Use File-->Save Workspace option to save the open workbooks as a sample.xlw
Opening sample.xlw will open all linked workbooks

If this post is helpful click Yes

 

[Mike Lang]

Thanks for the suggestion but we use Office 2003 which I don't think has
this function and the Master has to be a template .xlt

Any other ideas?

 

[Jacob Skaria]

Hi Mike

This is even with 2003. Please try.

If this post is helpful click Yes

 

[Mike Lang]

Thanks very much - found it!

Does this save as a template though?