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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
Excel Links
Do you have an attachment of this file, just for check your problem?
--- Message posted from http://www.ExcelForum.com/ |
#3
|
|||
|
|||
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 | |
|
|
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 |