Exporting

[pujo]

Can you export a worksheet from a workbook to use in other workbooks?
Each workbook is the same format, just different data. When I tried this, all the formulas were linked to the workbook that I copied the sheet from?
I know its simple. just don't know how.
Thanks for any info.
Pujo

 

[litrelord]

Hi Pujo,

you can do it just as you said but then you need to change the references so it's pointing at the new workbook.

In Excel 2007 choose 'Edit Links' from the Data menu. In previous versions I think it's called 'Links' under the edit menu. Choose link that's pointing to the workbook you copied from and choose 'Change Source'. Navigate to the current workbook and change it to that. Excel should update all the links automatically for you after this.

Hope this helps

Nick

 

[pujo]

I'm using 2003.
Thanks for the assistance.

Pujo

 

[litrelord]

OK, well as I say, I think it's under the edit menu but I'm working from memory so if it isn't you'll need to hunt around a little.