Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I get linked data to update inserted rows Jean-Toledo Excel Discussion (Misc queries) 2 March 30th 07 10:04 PM
Updating multiple linked workbooks dk New Users to Excel 1 June 9th 06 12:33 AM
Linked Cells Staying With Cells Once Linked Workbook Update. [email protected] Excel Worksheet Functions 0 June 6th 06 09:32 AM
Keep cells in two different workbooks linked after delete/insert r KarenM Excel Worksheet Functions 0 September 22nd 05 05:41 PM
insert rows and update linked cells Laura Excel Discussion (Misc queries) 2 August 26th 05 07:52 PM


All times are GMT +1. The time now is 02:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"