close

I do not know why this spreadsheet keeps locking up.


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--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=532816Pam,

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?

--

quot;pamquot; wrote:

gt; I do not know why this spreadsheet keeps locking up.


Could this be your problem?

tinyurl.com/m88ac--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=532816

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()