View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Money Money is offline
external usenet poster
 
Posts: 1
Default Working on Excel

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.