links

[Ryan]

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.

 

[Guest]

Yes, sorry.

I have a very large Excel file that contains a lot of data
on a lot of different things. I link specific data from
this file to another Excel file. In this file I create
Charts and Tables that I then link to different PowerPoint
presentations. At the minimum there are three different
files linked from 1 to 2 to 3.

 

[Vaughan]

Aha!

OK I think I can guess what your problem is. You have the data in one excel file, and your "reporting" in another. That is fine, unless you change the structure of the data file *while the reporting file is not open*.

If your reporting file displays the contents of Sheet1!A1 of your data sheet, as long as it is open, it tracks what happens to that cell, so if you insert a line above it and it becomes Sheet1!A2, then as long as your reporting sheet is open when you do that it will log that the source of its data has become Sheet1!A2. If it isn't open, it can't know about the change, so when you open your reporting sheet it will still be expecting to find it's source in Sheet1!A1.

The answer is to incorporate your reporting sheets in the same file as your data, or at least to make sure that they are both open before you make any structural changes.

 

[Guest]

That works perfectly! Thank you.

-----Original Message-----
Aha!

OK I think I can guess what your problem is. You have the

data in one excel file, and your "reporting" in another.
That is fine, unless you change the structure of the data
file *while the reporting file is not open*.

If your reporting file displays the contents of Sheet1!A1

of your data sheet, as long as it is open, it tracks what
happens to that cell, so if you insert a line above it and
it becomes Sheet1!A2, then as long as your reporting sheet
is open when you do that it will log that the source of
its data has become Sheet1!A2. If it isn't open, it can't
know about the change, so when you open your reporting
sheet it will still be expecting to find it's source in
Sheet1!A1.

The answer is to incorporate your reporting sheets in the

same file as your data, or at least to make sure that they
are both open before you make any structural changes.