Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Oct 2001
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatting (Excel 97)

    For the past couple of years I have been creating spread sheets in which the row height & column width are very important. Recently, I am having problems with losing my formatting. I will format a document, & save it. When I close it & open it back up again, the formatting is all different from what I saved it as. These are protected files, so I know someone else is not going in there & changing them on me. As far as I know, I'm not doing anything differently. Any ideas?

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Formatting (Excel 97)

    epagano

    It is always nice to know what exactly is changing, Row Heights, colors, Borders?

    If you can check to see if it happens on a different machine, maybe your Excel is going Gaga...

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Star Lounger
    Join Date
    Apr 2001
    Location
    Winchester, Hampshire, United Kingdom
    Posts
    64
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Formatting (Excel 97)

    Does your formatting always return to the same thing, albeit different from what you saved in that prticular worksheet? If so, then your worksheet, or possibly even your BOOK.XLS (or .XLT) may have been corrupted. Excel reads standard layouts from this file and then the settings for each file it loads. If one has become corrupted then it will return to your default settings. If you have a backup of your worksheet, try loading that to see if that cures the problem.

  4. #4
    npsarros
    Guest

    Re: Formatting (Excel 97)

    Have you recently changed printers?
    Try re-installing the printer driver. Also try the shhet on another PC

  5. #5
    New Lounger
    Join Date
    Oct 2001
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting (Excel 97)

    It seems to be the column width that changes. Also, any graphics that were in those columns had been smushed together along with the column. The row height, borders, colors, etc. seems to stay the same.

    It even happened when I e-mailed a copy of the file to someone else. When I saved & closed the file it looked fine. When the person I mailed it to opened it, it was all messed up.

    If my excel has "gone gaga" what is the solution?

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting (Excel 97)

    I might suggest a few things:

    1- Are there any macros in the workbook, and in particular code in any of the event routines. This code could be getting triggered when you save the workbook and be changing the formatting.

    2- Check your system for viruses with a good up-to-date virus checker.

    3- Take the file to another system and open it there. If the formatting is messed up, fix it and save the file there. If the formatting is again messed up when you open the file on that system, the the problem is in the file. It could be some kind of corruption. Try to find an Excel 2000 system, open the file there, save it in HTML format, open the HTML file and save it back as a .xls file. This might fix the problem. If the problem does not reoccur after saving the file on the other system, then your copy of Excel may be corrupted. Remove Excel and reinstall.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •