3-D References and Link Updates

I

IKB1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating an average of data between two dates 1
Links not updated when primary worksheet is sorted 4
Insert row treated differently depending on link destination 0
Update OLE Links in Powerpoitn from Excel 0
Export Sheet Values to new workbook 20
Adding a row to worksheet does not update cell references in another. 5
3-d references 4
update links in Powerpoint 2007 2

Top