Karthik Ganeshan
New Member
- Joined
- Jun 17, 2020
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
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.
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.