• Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

How to fix Excel file format error after saving and closing

0 Comments

How to fix Excel file format error after saving and closing: You have entered data and made a lot of edits to an Excel file such as font, color, size, table borders, etc. You have also saved the file and closed Excel. However, when you reopen it, the data inside is corrupted with font errors, or the formats you just saved have completely disappeared. What should you do then? In fact, fixing Excel file format errors or font errors is not difficult, but it is important to know how to do it. Read the following article to learn how to fix it.

If you open an Excel file with corrupted data format like the image below, follow the steps below to fix this issue.

1. Fixing by manually deleting Styles

In most cases, the reason why Excel files lose formatting after saving is due to excess Cell Styles. Therefore, you need to delete unnecessary Cell Styles. To do this, first select the Home tab on the toolbar. Then click on Cell Styles.

How to fix Excel file format error after saving and closing

How to fix Excel file format error after saving and closing

Now, the scroll bar will display the Styles available in your worksheet. You just need to find strange formats, foreign languages, etc. then right-click and select Delete to remove them.

How to fix Excel file format error after saving and closing

How to fix Excel file format error after saving and closing

2. Using VBA to automatically delete Styles

First, select the Developer tab on the toolbar. Then click on Visual Basic. Or you can use the shortcut key combination Alt + F11 to open the VBA window.

How to fix Excel file format error after saving and closing

How to fix Excel file format error after saving and closing

Now the VBA window appears, select the Insert tab on the toolbar. The scroll bar appears, select Module.

How to fix Excel file format error after saving and closing

How to fix Excel file format error after saving and closing

Next, copy the code below into the Module dialog box. Then click the Run icon on the toolbar or press F5 to run the code. That way, all the excess and corrupted Styles in your file will be quickly deleted.

Sub StyleKill()
Dim styT As Style
Dim intRet As Integer
On Error Resume Next
For Each styT In ActiveWorkbook.Styles
If Not styT.BuiltIn Then
If styT.Name <> “1” Then styT.Delete
End If
Next styT
End Sub

How to fix Excel file format error after saving and closing

How to fix Excel file format error after saving and closing

3. Choose the format when saving the file

Another cause of formatting errors when saving files is selecting the wrong file format. To save the file with the full format and without errors, you need to select Excel Workbook (*.xlsx) at the Save as type. That way, your Excel file will be saved normally without losing formatting.

How to fix Excel file format error after saving and closing

How to fix Excel file format error after saving and closing

So, the above article has guided you on how to fix Excel file format errors after saving and closing. Hopefully, the article will be helpful to you in your work. Wish you success!

6
78 Views
How to show/hide Sheet Tabs in ExcelPrevHow to show/hide Sheet Tabs in ExcelMarch 16, 2023
How to increase the number of Undo operations in Word, ExcelMarch 16, 2023How to increase the number of Undo operations in Word, ExcelNext

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts
  • Retrieve Data Based on Data Validation
    September 7, 2023
    Excel
  • How to Convert Multiple Rows to Columns and Rows in Excel?
    September 6, 2023
    Excel
  • VLOOKUP for Automatic Discount in Data Validation
    September 6, 2023
    Excel
  • How to Convert Text Dates to Dates in Excel?
    September 5, 2023
    Excel
Categories
  • Blog 80
  • Excel 754
  • Powerpoint 36
  • Software tricks/tips 128
  • Uncategorized 8
  • Word 109
Tags
the ISERROR
Top rated products
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
  • Trend Micro Maximum Security 3 Devices 1 Year key Global Trend Micro Maximum Security 3 Devices 1 Year key Global
    Rated 5.00 out of 5
    $15.00
  • Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $15.00
  • Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $45.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
Products
  • Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $45.00
  • Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account
    Rated 4.83 out of 5
    $49.00
  • Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $15.00
  • Windows Server 2022 Standard Key Global
    Rated 4.47 out of 5
    $15.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $45.00

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.