How do I clean up an Excel workbook so it uses less memory?

To remove conditional formatting, follow these steps:

  1. Save a backup of the file.
  2. On the Home Ribbon, click Conditional Formatting.
  3. Clear rules from the whole worksheet.
  4. Follow steps 2 and 3 for each worksheet in the workbook.
  5. Save the workbook by using a different name.
  6. See if the problem is resolved.

For More Information Please Refer:


You May Also Like to Read: