Associated Spreadsheets

**Yuanhang** · November 30th 07, 06:31 PM posted to microsoft.public.excel.misc

I referenced a spreadsheet with a master spreadsheet, that is, all the cells
are well linked. However, sometimes, I wanna delete some rows or columns from
the master spreadsheet. As a result, the corresponding cells in the other
spreadsheet show #REF! up rather than being deleted as I expected.

**Jim Thomlinson** · November 30th 07, 06:59 PM posted to microsoft.public.excel.misc

And what you have posted is one of the reasons why I never link spreadsheets.
Deleteing cells in one workbook does not delete the refence in the other
workbook(s). If you intend to change one book you need fix the other book(s)
also. There is no easy way around it and there is no way to know what other
books might be linked back to the master.
--
HTH...

Jim Thomlinson

"Yuanhang" wrote:

> I referenced a spreadsheet with a master spreadsheet, that is, all the cells
> are well linked. However, sometimes, I wanna delete some rows or columns from
> the master spreadsheet. As a result, the corresponding cells in the other
> spreadsheet show #REF! up rather than being deleted as I expected.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
spreadsheets	ray shoey	Excel Worksheet Functions	2	July 27th 07 01:57 PM
spreadsheets	jill	Excel Worksheet Functions	1	July 6th 07 05:18 AM
Can Excel Spreadsheets be saved as Microsoft Works spreadsheets?	EXCEL WORKS CONFUSED	Excel Discussion (Misc queries)	4	August 18th 06 11:21 PM
Spreadsheets	Patty	Excel Worksheet Functions	1	August 9th 06 02:01 AM
Spreadsheets	speed1104	Excel Discussion (Misc queries)	5	January 27th 06 05:11 PM