• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • 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
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • 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
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • 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
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • 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!

Rate this post
35
295 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

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
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 Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $6.00
  • Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
Products
  • Windows 11 Pro Product Activation Key Windows 11 Pro Product Activation Key
    Rated 5.00 out of 5
    $6.00
  • Avast Premium Security 2021 Avast Premium Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Microsoft Visual Studio Enterprise 2022 For 1 PC Microsoft Visual Studio Enterprise 2022 For 1 PC $19.00
  • Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year $284.73
  • Microsoft Visio Professional 2010 Key 1PC Microsoft Visio Professional 2010 Key 1PC $9.00
  • Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account
    Rated 4.92 out of 5
    $15.00
  • 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
  • Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account
    Rated 4.71 out of 5
    $99.00
  • SQL Server 2019 Standard SQL Server 2019 Standard $20.00
  • 5 Key Windows 10 Pro Key Global - Combo 5 KEY 5 Key Windows 10 Pro Key Global - Combo 5 KEY
    Rated 4.81 out of 5
    $25.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

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.