Excel 3.0 spreadsheet opens then clocks continuously

Hi Experts,

Hope you can help me. I'm making changes to a VBA-driven spreadsheet in Excel 3.0. OS is Windows 7. Had to stay with Office 3.0 for compatibility with other systems. I've finished the spreadsheet and am testing the VBA code. I made a change to the code, saved the spreadsheet and closed out iof it momentarily. When I opened the spreadsheet back up, it just sits there clocking - It won't let me access any of the cells. I can't stop it from clocking by using CTL + Break or Esc. The only way to stop it is to shut Excel down completely. I don't kno why it's doing this. It's small by spreadsheet standards: 2,734K.

Can anybody tell me why this might have happened and what I might be able to do to re-access this spreadsheet?

Thanks,

taduh
taduhFinancial Systems AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Richard QuadlingSenior Software DeveloperCommented:
Can you try the following...

Open Excel
Use the Open dialog to find your spreadsheet.
Hold the shift key down to stop the running of macros and click the 'open' button.

Hopefully, this will stop any macros from running on the spreadsheet.

You should then be able to start checking the code.


Also, open excel and create a new spreadsheet. Check the automatic recalc option. Turn this off and then try loading the spreadsheet. Untested, but the recalc option may be system level.
0
redmondbCommented:
Hi, taduh,

A simple mistake could result in a permanent loop.

To stop the macro from running when you open the file, please hold down the "Shift" key when you click on the file to open it.

Edit: Apologies, RQuadling, crossing posts.

Regards,
Brian.
0
taduhFinancial Systems AnalystAuthor Commented:
No - thanks for the input, but that didn't work. It immediately came up with the round blue ring (clocking) and said "Not Responding".
0
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Richard QuadlingSenior Software DeveloperCommented:
How about setting the macro security level to the highest possible. Hopefully that should stop the macros from running.

This is of course assuming it is a macro issue.

OOI. Can you load a copy of this spreadsheet into a modern version of Excel? Using the same Shift key technique to stop macros.
0
taduhFinancial Systems AnalystAuthor Commented:
I don't think it's a macro issue. There are no macros that run On Open. I'll see if someone who has Excel 7.0 can open it.
0
redmondbCommented:
taduh,

On the off-chance that there's no confidential information in the file, please post it here.

Edit: Oops - VBA didn't appear until Excel 5. Please confirm the version of Excel you are using.

Thanks,
Brian.
0
taduhFinancial Systems AnalystAuthor Commented:
Sorry Brian - wish I could, but can't.... any suggestions- what were you going to try?
0
redmondbCommented:
taduh,

wish I could, but can't
Thanks anyway - not a surprise!

what were you going to try?
Try to open it with various versions (my oldest is 2000). Probably run in through a hex editor.

You may have missed the edit to my last post - VBA was only added to Excel in Excel 5. Please go in to "Help" and "About" (assuming they're there!) to confirm your version number.

Thanks,
Brian.
0
taduhFinancial Systems AnalystAuthor Commented:
Sorry - don't know what I was thinking - Excel 2003.

Thanks!

taduh
0
redmondbCommented:
Thanks, taduh.

Next step depends on the file version - xls, xlsm or xlsb?

BTW, if you're stake-your-life-certain that there are no event or Auto_Open macros and you blocked any macros from running any way, then the file is likely corrupt unless there's a huge amount of something - rows, conditional formatting and shapes are frequent candiates.

Thanks,
Brian.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
taduhFinancial Systems AnalystAuthor Commented:
Folks,

The only way I found around this problem was to re-create the spreadsheet by starting with a fresh spreadsheet and copying the elements off of each worksheet in the corrupt workbook and pasting them into the corresponding worksheet in the new workbook then recreating my named ranges. Then, I did the same sort of thing with the code. I never had a problem with it hanging after that so there must have been something in the “bowels” of the old workbook that got corrupted.

I appreciate all the suggestions.

taduh
0
redmondbCommented:
taduh,

Yes, I was afraid of that. Is there anything else we can do for you?

Regards,
Brian.
0
taduhFinancial Systems AnalystAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for taduh's comment #a38811855

for the following reason:

While I had hoped for a better solution, nothing seemed to work except to re-build the spreadsheet using a new workbook for the foundation and pasting in the elements from the old sheet to get away from the corruption inherent in the old spreadsheet.

No disrepect to the Experts that we're trying to help me; there simply wasn't a better solution - the old workbook was corrupt - plain and simple.
0
taduhFinancial Systems AnalystAuthor Commented:
No, but thanks, Brian. I appreciate your efforts!
0
redmondbCommented:
Hi.

The OP's is requesting that his/her post be flagged as the solution because...
the old workbook was corrupt - plain and simple.
...however, a week ago I had identified this for the OP...
...the file is likely corrupt...

So, I would like this post selected as the answer.

This is not about the points (by all means, reset them to 0) - the OP was walked through to the source of his/her problem and this should be shown as the solution.

Thanks,
Brian.
0
redmondbCommented:
Please see the previous post.
0
redmondbCommented:
Thanks, modus_operandi.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.