3-D References and Link Updates
 

We are using 3-D references at work. So for example we have sheets 00 and 99
as the beginning and end sheets, sheet01 sheet 02 and sheet03 are between
them. The data in these sheets links to a summary sheet.

In files over 9MB (which is small for my work), we are encountering problems
with links not updating. When we move a sheet from outside the range to
between 00 and 99, the links stop updating on the summary sheet. Ditto if we
duplicate a sheet that is between sheet00 and sheet 99.

Is there a problem with excel and 3-D References when the file sizes are
over a certain amount? We aren't having problem on smaller files.

thanks!

ikb