Excel 2003 Linking worksheets

**Barb4444** · 05-05-2009, 01:24 PM

I need to link a freestanding spreadsheet to a page in another workbook

**ChemistB** · 05-05-2009, 01:43 PM

You need to be a little more clear on what you are trying to achieve. To link cells to another workbook, you refer to the workbook in brackets like so

Please Login or Register  to view this content.

Is that what you are looking for?

**Barb4444** · 05-05-2009, 03:45 PM

I am actually trying to link an entire spreadsheet (not just one cell) to a page in another workbook. I want changes made to the source sheet, which will then update in the workbook

**ChemistB** · 05-05-2009, 04:34 PM

You can take that formula I gave you and drag it down as far as you want to go and across as far as you want to go. It will not link formats so you will need to set up your formats separately (or copy and paste special >formats).