Excel 2002 dropping gridlines and window panes when saved as a work space

[Pete Dixon]

Does anyone know why Excel might drop thise setting when saving is don
via the Workspace option? Simply saving the spreadsheet independentl
brings back the gridline off option and the saved window pane
properly.

I assume other non-cell specific formatting options are being lost a
well.

Curiously the gridline option is being kept on other files in the sam
workspace. Weird!

Pet

 

[Jim Rech]

Although this article is for Excel 2000 it seems to be similar to your
problem, so for what it's worth:

http://support.microsoft.com/default.aspx?scid=kb;en-us;214297&Product=xlw

--
Jim Rech
Excel MVP

| Does anyone know why Excel might drop thise setting when saving is done
| via the Workspace option? Simply saving the spreadsheet independently
| brings back the gridline off option and the saved window panes
| properly.
|
| I assume other non-cell specific formatting options are being lost as
| well.
|
| Curiously the gridline option is being kept on other files in the same
| workspace. Weird!
|
| Pete
|
|
| ---
| Message posted
|