ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Working on Excel (https://www.excelbanter.com/excel-discussion-misc-queries/175741-working-excel.html)

Money

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.


All times are GMT +1. The time now is 08:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com