In this case, the problem appears to be confined to a particular Spreadsheet and the Excel Program itself is working fine. In many cases, this problem can be fixed by clearing conditional Formatting from the spreadsheet.ġ. Open the Excel File that is getting stuck on your computer.Ģ. On you are in the file, click on Home > Conditional Formatting > Clear Rules > Clear Rules From Entire Sheet.
This will clear Conditional Formatting from this particular sheet.ģ. Now, select other Tabs (in case you have any) from the bottom of the sheet and clear Conditional Formatting in those sheets as well.Ĥ. Save this Excel File with a New Name, so that the original Excel File will also be available on your computer. You will be able to make use of the original File, in case required. If this fixes the problem, it confirms that the file is getting stuck due to conditional Formatting. #Excel vba on error not working windows#.
0 kommentar(er)
