Excel takes a lot of time to respond when i hit enter button

[Karthik Ganeshan]

I have a macro enabled excel file which is only 700 KB.

Whenever i edit any cell and hit 'enter', it takes almost 45 seconds to respond. I do not have any vba program linked to any cell change event. I checked the used range for all the sheets, and none of the sheets go beyond 15 to 20 columns or 300 to 400 rows. There is no conditional formatting anywhere in the file. I even made formula calculation to 'manual'. There are no external links. There are no external references in the name manager. There are no data connections.

I am at a loss to understand why the excel is behaving like this.

 

[RoryA]

Welcome to the forum.

Is it the only workbook you have open? Does the same thing happen if you open Excel in Safe Mode (hold down the Ctrl key while starting Excel and answer Yes to the prompt)?

 

[Yongle]

Welcome to MrExcel
Are there any array formulas anywhere in the workbook ?

 

[Karthik Ganeshan]

Welcome to the forum.

Is it the only workbook you have open? Does the same thing happen if you open Excel in Safe Mode (hold down the Ctrl key while starting Excel and answer Yes to the prompt)?

Hi. Thanks for your response. Yes, it happens even if it is the only workbook open. I tried it in Safe Mode as well. The behaviour is the same.

 

[RoryA]

Do you have any event code in the workbook? Eg Worksheet_SelectionChange?

 

[Karthik Ganeshan]

Do you have any event code in the workbook? Eg Worksheet_SelectionChange?

There is code in the following events. Tried commenting it as well, but the problem prevails
Workbook_BeforeClose
Workbook_Open()
Workbook_SheetBeforeRightClick

 

[Karthik Ganeshan]

I noticed one more thing just now. Would like to hear from you if this could be causing any issue. If you see the screenshot, there are two sheets that don't have a name. These sheets are not visible anywhere in the workbook. I cannot remove them either.

 

[RoryA]

That looks like corruption to me. The icon for those two sheets is the Workbook icon, not a worksheet icon. Can you put the file somewhere (eg OneDrive, or Dropbox, or similar) for me to look at?

 

[Karthik Ganeshan]

That looks like corruption to me. The icon for those two sheets is the Workbook icon, not a worksheet icon. Can you put the file somewhere (eg OneDrive, or Dropbox, or similar) for me to look at?

I have placed it in Dropbox. How do i share?

 

[RoryA]

You should be able to just select the file (in Dropbox online) and click the Share button to get a link.