Excel 2003 crashes when entering data

I have actually this excel file and it freezes once I"m entering information. For circumstances, I double click on a cell, enter the information and also as soon as I press " enter ". It freezes instead of going to the cell underneath. Pressing " enter " a number of times does not unfreeze the routine, the only point that functions is picking another cell through the computer mouse.

You watching: Excel 2003 crashes when entering data

This excel sheet has even more or much less 10 sheets and I have actually two or three macros however this difficulty persists also as soon as I"m disabling the macros.

I have tried to run this excel file on two various Macs and also both of them experience the same trouble.

Any ideas?


*

*

Disable Flash fill under file > options > advanced > editing and enhancing options > "instantly flash fill" This is a known problem with Excel!


*

*

Had the very same concern happen to me today.I was modifying an Excel workbook that had actually cells referenced in another workbook that was open up at the moment.When I entered a value, the worksheet I was on would not respond, going to one more worksheet and entering a value then escaping would certainly "reset" and I would certainly have the ability to go earlier to the worksheet to resume occupational, however would get "stuck" aacquire ideal after entering an additional value.

See more: Wireless Access Point Without Ethernet Cable ? Wireless Access Point Without Ethernet Cable

Solved the problem by cshedding the other Excel workbook that was referencing cells in the workbook I was working on.


*

Thanks for contributing a solution to Stack Overflow!

Please be sure to answer the question. Provide details and also share your research!

But avoid

Asking for help, clarification, or responding to other answers.Making statements based upon opinion; ago them up via references or personal suffer.

See more: Latest Driver Stuck On Installing 3D Vision Driver Stuck, Stuck On Installing 3D Vision Driver

To learn more, check out our tips on creating excellent answers.


Article Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie plan


Not the answer you're looking for? Browse other questions tagged excel freeze vba or ask your very own question.


site design / logo © 2021 Stack Exchange Inc; user contributions licensed under cc by-sa. rev2021.4.5.38984


Your privacy

By clicking “Accept all cookies”, you agree Stack Exadjust deserve to save cookies on your tool and discshed information in accordance with our Cookie Policy.