We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Excel sheet 'not responding' every time I open it
londonman81
Posts: 1,130 Forumite
in Techie Stuff
I have started running an Excel sheet which collects data throughout the day for later analysis.
I have been able to save a copy of the sheet but when I open it my Excel suddenly goes into 'Not Responding' mode.
The sheet displays in part but I can't scroll around and click into cells etc (ie.e edit in any way).
The file is around 15MB large and my CPU usage suddenly jumps to 100% when this file opens.
Since the data is important I need some way to get to it.
My computer has 512mb RAM, P4 2.8 Ghz - its a Dell Dimension 3000. Could this be the problem?
TIA!
I have been able to save a copy of the sheet but when I open it my Excel suddenly goes into 'Not Responding' mode.
The sheet displays in part but I can't scroll around and click into cells etc (ie.e edit in any way).
The file is around 15MB large and my CPU usage suddenly jumps to 100% when this file opens.
Since the data is important I need some way to get to it.
My computer has 512mb RAM, P4 2.8 Ghz - its a Dell Dimension 3000. Could this be the problem?
TIA!
"To be ignorant of one's ignorance is the malady of the ignorant." Amos Bronson Alcott
0
Comments
-
Is the hard disk getting thrashed a bit while opening? If so you need more RAM (512MB isn't much for XP anyway).
Try opening it in an Office compatible program such as Open Office to see if it will load in that. You may find the script in the sheet (assuming it has some vbscript) may be buggy.Windows is the path to the darkside...Windows leads to Blue Screen. Blue Screen leads to downtime. Downtime leads to suffering...I sense much Windows in you.0 -
A-Wing wrote:Is the hard disk getting thrashed a bit while opening? If so you need more RAM (512MB isn't much for XP anyway).
Try opening it in an Office compatible program such as Open Office to see if it will load in that. You may find the script in the sheet (assuming it has some vbscript) may be buggy.
The VB code is very simple - it just loops many times taking data off a website along the way.
I will try opening it in OpenOffice....but i'm not hopeful :-("To be ignorant of one's ignorance is the malady of the ignorant." Amos Bronson Alcott0 -
Is it a timer based loop? If so you may find it is executing before the last execute completed, causing a cascade effect.Windows is the path to the darkside...Windows leads to Blue Screen. Blue Screen leads to downtime. Downtime leads to suffering...I sense much Windows in you.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.2K Reduce Debt & Boost Income
- 455.1K Spending & Discounts
- 246.6K Work, Benefits & Business
- 603K Mortgages, Homes & Bills
- 178.1K Life & Family
- 260.6K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards