Web Development

Ask something
Discussion Locked

Excel bug

0 helpful
8 replies

by rackin

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We have a spreadsheet with fairly extensive VBA code behind it to perform updates and calculations. After the sheet has ran for about 30 minutes the functions in cells stop calculating. If you cut the function out of the cell and paste it in again it will start calculating again. Anyone ever ran into this and knows how to fix it?

Thanks

Rod

8 replies

by sgt_shultz

you don't mention your os or excel versions and service pack levels. start by applying all critical os and office updates. let us know more about the environment and consider posting the code

by sgt_shultz

i surfed to support.microsoft.com and searched for 'excel hang code' all words and saw some entries that might give you a place to start.

by rackin

Sorry,
It is Windows 2K SP3 with office 2000 SP3. There is too much code to post, but a single run through of the code does not cause a problem. after running for about 30 min then the sheet stops calculating, although the code runs still, just cells stop updating. unless you cut and paste the funcion in the cell.

by dklippert

Here's a site that may have some answers for you.

www.decisionmodels.com/calcsecrets.htm

Other reported problems have been User Defined Functions and memory overflow. If you are performing iterative procedures, you might consider inserting some sort of buffer clearing code.
Calculation can also be goosed by just replacing "=" with "="

by cactus pete

Perhaps not the solution, but a faster workaround might be to hit F2 on the cell instead of cutting and pasting again.

by -keyteck

I ran into a similar situation where code hangs up, this was due to the OS. The best thing to do is to add "DoEvents" in a long code process or in a short process with a lot of calculations, this is to free up the OS's resources and catch up with other processes. -walter

This discussion is closed to new replies.