Share via

Excel keeps locking up

Anonymous
2018-04-21T00:19:06+00:00

I get a "not responding message" and it freezes.  I have to use task manager to close it.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2018-04-22T06:09:14+00:00

    I have to see your file, from your description can not recognize what happened.

    Please upload your file (maybe with anonymous data) on an online file hoster like www.dropbox.com and post the download link here.

    A macro to anonymize data in selected cells can be downloaded here:

    https://www.dropbox.com/s/rkfxuh85j5wyj9y/modAn...

    Andreas.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-04-22T00:40:04+00:00

    First, my Excel keeps creating "autographs" which aren't visible but inhibit editing a cell.  I was trying to delete m from the selection pane

    Second, I was trying to copy/paste whole cells of information.

    Was this answer helpful?

    0 comments
  3. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2018-04-21T08:30:40+00:00

    The reasons can be very different, so what did you do just before it freezes?

    Andreas.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-04-21T00:27:44+00:00

    Hi,

    Solution:

    Execute below steps and check after each

    1. Please look into C:\Users\User_Name\AppData\Roaming\Microsoft\Excel (replace user name with your user name, you can directly reach here by copy and pasting following without quotes in Explorer address bar - "%appdata%\Microsoft\Excel") and see if is contains few files / folders. Move those files to some other location (i.e create a backup of those files / folders and delete all files / folders from here). Hence, make Excel folder blank.

    Now open Excel and see if the problem disappears or not.

    Note - If the above path is not applicable for your installation, you need to find XLSTART path. Excel folder contains XLSTART folder in itself (In case, your XLSTART path is not in Appdata)

    Open Excel > ALT+F11 > If Immediate Window is not visible, type CTRL+G. Same can be also be accessed through View > Immediate Window > Type "? application.StartupPath" without quotes and press enter > You will have your path below.

    1. Try repairing your office installation. First try Quick Repair (takes 5 - 10 mins) , if that doesn't help then try Online Repair (Takes more than 30 mins but less than 1 hour in general)

    https://support.office.com/en-us/article/Repair...

    I hope it helps.

    Best Regards,

    Diego R.

    Was this answer helpful?

    0 comments