G
Guest
I've got a huge problem.... I've been working on a
financial model for a month... basically a large budget in
Excel... multiple files (150) with multiple sheets. All
the files are placed in folders representing a hierarchy.
I'm trying to "rollup" summarized statements that are
consistent within all files to one Total file.
My problem is that everything is carefully linked and now
when I look at my linked cells, the data is there but when
I F2 calc I get a #ref. The data looks o.k. but now I
think I might have a problem. Does anyone know if there is
a limit to the size of a linked cell? or is it just the
limit of characters like any other?
Thanks!
financial model for a month... basically a large budget in
Excel... multiple files (150) with multiple sheets. All
the files are placed in folders representing a hierarchy.
I'm trying to "rollup" summarized statements that are
consistent within all files to one Total file.
My problem is that everything is carefully linked and now
when I look at my linked cells, the data is there but when
I F2 calc I get a #ref. The data looks o.k. but now I
think I might have a problem. Does anyone know if there is
a limit to the size of a linked cell? or is it just the
limit of characters like any other?
Thanks!