I have an excel spreadsheet that keeps locking up on me, I need he

J

John James

Nor do I.



Any other clues?

e.g.
Size of file? Complexity of calculation? Array formulae? Speed of
recalculation? Can you open it and it later locks? What precedes it
locking? Do you have an earlier version that doesn't lock? Latest
changes made before lockups occurred?
What's your strategy if you can't get this file working? Does it work
on another PC (perhaps a newer one)? etc
 
B

Bryan Hessey

Pam,

Which System and version of Excel are you using, and was the Workbook
created on a prior vesion of Excel?

Is the workbook very large? - do you get warnings about Circular References?
- do you have a lot of references to other books?

Is there any VBA code in this workbook? Do you have Adobe Acrobat loaded?

Any further clues?

Can you easily create a new workbook, and for each sheet, Copy and Paste
Formats, then Copy and Paste all data?
 
Top