insert rows and update linked cells in multiple workbooks
 

To whomever my know the answer:

We just recently upgraded some users to Office XP to fix a heap space
issue with a rather large excel file that contained tons of links and
lots of formulas. It was a real beast. Now after several weeks of
use a "bug" or problem has come up.

Here is the scenario. I have multiple workbooks that are linked to
one source workbook. So for instance. Test1.xls is my source. In
Test2.xls and Test3.xls there is a link to rows in Test1.xls.
Supposedly in Excel 2000 if you inserted a row into the source
workbook, Test1.xls in this case. It would duplicate that change into
the linked workbooks "if they are open..." as the users stated.

So now I am trying to figure out what option might need to be changed
or if this "bug" was just an accident in Excel 2000.

If anyone could suggest a course of action I would appreciate it. I
tested this out on Excel XP and it didn't work like they said. I am
going to track down a Excel 2000 install and make sure but I have no
reason to doubt multiple users.

insert rows and update linked cells in multiple workbooks
 

I would suggest that users are misremembering.

I know of no version that would insert rows in target workbooks/sheets when a
source worksheet had rows inserted.

Without the use of VBA that is.


Gord Dibben MS Excel MVP

On 2 Apr 2007 13:57:12 -0700, "
wrote:

To whomever my know the answer:

We just recently upgraded some users to Office XP to fix a heap space
issue with a rather large excel file that contained tons of links and
lots of formulas. It was a real beast. Now after several weeks of
use a "bug" or problem has come up.

Here is the scenario. I have multiple workbooks that are linked to
one source workbook. So for instance. Test1.xls is my source. In
Test2.xls and Test3.xls there is a link to rows in Test1.xls.
Supposedly in Excel 2000 if you inserted a row into the source
workbook, Test1.xls in this case. It would duplicate that change into
the linked workbooks "if they are open..." as the users stated.

So now I am trying to figure out what option might need to be changed
or if this "bug" was just an accident in Excel 2000.

If anyone could suggest a course of action I would appreciate it. I
tested this out on Excel XP and it didn't work like they said. I am
going to track down a Excel 2000 install and make sure but I have no
reason to doubt multiple users.