A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel Links



 
 
Thread Tools Display Modes
  #1  
Old July 15th, 2004, 09:33 PM
Ryan
external usenet poster
 
Posts: n/a
Default Excel Links

I have a large excel file with cells that I link to charts
on another worksheet, and then link those charts to
powerpoint presentations.

My problem resides in when my boss has me add additional
rows to the file. It moves all of the data I have linked
to different cells, which in turn messes up all the data
that I have linked.

I have too many files linked to this one file. I can't
separate the data from that file, and I need to be able to
insert data in the middle of excel file.

Is there a way I can track these links so they change when
the data moves without manually changing (literally
hundreds) all of the links?
  #2  
Old July 15th, 2004, 09:53 PM
iguzman
external usenet poster
 
Posts: n/a
Default Excel Links

Do you have an attachment of this file, just for check your problem?


---
Message posted from http://www.ExcelForum.com/

  #3  
Old July 16th, 2004, 03:46 PM
external usenet poster
 
Posts: n/a
Default Excel Links

There is no point in attaching the file, since it links to
about 20 other files, and each of those files links to
about 10 power point presentations.

but the problem i'm having, and i've tested this in a very
slimmed down version of the big file, is that when I
insert rows above data that is linked, the linked cells
don't change, just the data in them. So if I have two
rows of data (row one and two), and then insert a row
above them, then the other documents will show one blank
row of data (the new inserted row) and one row of data
(row one) instead of showing both rows of data (row one
and two). I'm looking for a way to have the links watch
the cells, and if they move then for the link to reflect
that.


-----Original Message-----
Do you have an attachment of this file, just for check

your problem?


---
Message posted from http://www.ExcelForum.com/

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Random links occuring in linked object from Excel Kelly Tables 1 June 15th, 2004 03:37 PM
Turn Excel spreadsheet links off from an Access database Ricardo New Users 2 May 19th, 2004 01:30 PM
Excel Links to files on network not updating Bobbie Jo Worksheet Functions 0 January 13th, 2004 10:02 PM
DDE Links extreamly slow in Excel 2002 Alex N. Links and Linking 4 December 30th, 2003 09:41 AM
Automatic Links in Excel 2003 Bernie Links and Linking 0 December 16th, 2003 03:16 PM


All times are GMT +1. The time now is 09:07 AM.


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