J
Juli
Hello all. I have a 8.5MB spreadsheet that is the
summary of weekly timesheets that are Excel files. I
have attempted various strategies to reduce the size of
the files. This sheet is all references to other
worksheets. Up until two days ago, when opening the file
and it asks, this contains references to other files...do
you want Excel to update the cell refences, y or N. I
always hit okay and it does it's stuff. Now however,
when the box comes up when opening the file, I hit okay
and it returns a "No Bound Sheets" error dialog box. All
I can do is hit okay and an error report is generated and
Excel closes. If I hit no the to update cell references,
then it is okay but does not update the file, which I
need it to do. I have checked the formulas/references
and they are correct. Is it because it is so big? Is
there a way around this issue? Please help because it is
critical to my job. I have searched Microsoft's website
to no avail. Any ideas?
summary of weekly timesheets that are Excel files. I
have attempted various strategies to reduce the size of
the files. This sheet is all references to other
worksheets. Up until two days ago, when opening the file
and it asks, this contains references to other files...do
you want Excel to update the cell refences, y or N. I
always hit okay and it does it's stuff. Now however,
when the box comes up when opening the file, I hit okay
and it returns a "No Bound Sheets" error dialog box. All
I can do is hit okay and an error report is generated and
Excel closes. If I hit no the to update cell references,
then it is okay but does not update the file, which I
need it to do. I have checked the formulas/references
and they are correct. Is it because it is so big? Is
there a way around this issue? Please help because it is
critical to my job. I have searched Microsoft's website
to no avail. Any ideas?