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...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top