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?