lost formatting

  1. ejpuck

    formatting lost after save and reopen

    Hello all. I recently opened a workbook, made many changes, saved with a new name, and when I reopened it, the formatting was gone...colors, lines backgrounds etc, though all the formulas are intact. This is a really large workbook with many tabs, and would take forever to reformat. Is there...
  2. J

    Excel will not save formatting

    I have a spreadsheet I have been using and updating successfully for years. Yesterday, i opened it and all formatting is lost. When i add formatting to the sheet and save it, the formatting is gone. Numbers and text values are saved, but no formatting can be saved. The version I am having...
  3. P

    Copy/paste loses cell formatting and data validation

    This is a well-known problem though I couldn't find a solution here or anywhere. When a protected sheet has cells which are not locked, but have formatting and data validation, a simple copy/paste into those cells from another sheet loses the formatting and validation in the target cells...
  4. C

    Excel 2007 Losing Formatting

    I have a user that is using Excel 2007 SP2 with all current updates. There is an Excel files (xlsx format) that he appends data to that seems to lose all formatting about once a week. He opens the file and Excel states that it has to repair and then removes all formatting. The user appends...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top