M
Money
Hi,
I have a 13.3 MB file with 3 worksheets in it. Sheet 1 is the Main Tab i.e.
the base data & has too many computations done using formulas almost in each
cell.
Sheet 2 & Sheet 3 are Summary Sheets which are purely based on Cell
Reference from Sheet 1.
I am suppose to Open this excel & Delete some columns in Sheet2 with "Shift
Cells to Left" option & then modify the cell refernces accordingly.
But I am unable to OPEN this file at all & incase I am able to Open this, I
am unable to Delete / Save my changes. The system simply "Hangs Up" and I had
to "End the Task".
Some of the observations:-
1) Each time I try to use this file, the CPU Usage goes to "100%"
2) I have some Hidden Text Boxes in Sheet 2. [I am trying to make updates on
Sheet2]
3) I am using MS Excel 2003 version.
Pls advise.
I have a 13.3 MB file with 3 worksheets in it. Sheet 1 is the Main Tab i.e.
the base data & has too many computations done using formulas almost in each
cell.
Sheet 2 & Sheet 3 are Summary Sheets which are purely based on Cell
Reference from Sheet 1.
I am suppose to Open this excel & Delete some columns in Sheet2 with "Shift
Cells to Left" option & then modify the cell refernces accordingly.
But I am unable to OPEN this file at all & incase I am able to Open this, I
am unable to Delete / Save my changes. The system simply "Hangs Up" and I had
to "End the Task".
Some of the observations:-
1) Each time I try to use this file, the CPU Usage goes to "100%"
2) I have some Hidden Text Boxes in Sheet 2. [I am trying to make updates on
Sheet2]
3) I am using MS Excel 2003 version.
Pls advise.