And you are saving the workbook as a normal workbook (*.xls)--not a text file
(like .prn or .csv), right?

Hank wrote:

In Excel 2003 I would like to Freeze the header row on each worksheet and
have this "Freeze Pane" save when the workbook is closed.

Should the Freeze pane save? If not, is there a way to do this so the
header rows are always visible. I can indicate which rows I want to print
at the top of each page with page setup. I'm trying to keep from haveing to
freeze pane each time I open the workbook.

Thanks
Hank

--

Dave Peterson

Dave,

Yes, I am saving as xls. All other changes to the workbook saved - except
the freeze pane.

As I asked earlier, could the fact that the row I am trying to freeze also
has auto filter have anything to do with it?
I have found out if I remove auto filter the freeze pane does save.

I really need the auto filter kept. Is there a work around?

Thanks
Hank

"Dave Peterson" wrote in message
...
And you are saving the workbook as a normal workbook (*.xls)--not a text
file
(like .prn or .csv), right?

Hank wrote:

In Excel 2003 I would like to Freeze the header row on each worksheet and
have this "Freeze Pane" save when the workbook is closed.

Should the Freeze pane save? If not, is there a way to do this so the
header rows are always visible. I can indicate which rows I want to
print
at the top of each page with page setup. I'm trying to keep from haveing
to
freeze pane each time I open the workbook.

Thanks
Hank

--

Dave Peterson

Are you sure that the freeze panes is being lost?

Next time, check to see if you see windows|Freeze panes or windows|Unfreeze
panes.

If you see unfreeze, then maybe the user didn't put the freeze in the correct
location.

If the data is filtered, then the freeze panes is applied, the user could have
put the freeze panes in the wrong location.

I put 1 to 20 in A1:A20.

Then I filtered to show the values 5. I selected A6 and hit window|freeze
panes.

Instead of making row 1 always visible, I made rows 1:5 always visible (I had to
show all the data to see that freeze panes line).

If the user does this where the first 200 rows are hidden, it can cause a
problem when data|filter|show all is used.

======
If that's not the cause, set your freeze panes.
Save the workbook.
Close excel

Start excel in safe mode
windows start button|Run
excel /safe

file|open yourfilename.xls

And see if things work ok. If they do this way, then you could have a "helpful"
macro that's removing that freeze panes.

Hank wrote:

Dave,

Yes, I am saving as xls. All other changes to the workbook saved - except
the freeze pane.

As I asked earlier, could the fact that the row I am trying to freeze also
has auto filter have anything to do with it?
I have found out if I remove auto filter the freeze pane does save.

I really need the auto filter kept. Is there a work around?

Thanks
Hank

"Dave Peterson" wrote in message
...
And you are saving the workbook as a normal workbook (*.xls)--not a text
file
(like .prn or .csv), right?

Hank wrote:

In Excel 2003 I would like to Freeze the header row on each worksheet and
have this "Freeze Pane" save when the workbook is closed.

Should the Freeze pane save? If not, is there a way to do this so the
header rows are always visible. I can indicate which rows I want to
print
at the top of each page with page setup. I'm trying to keep from haveing
to
freeze pane each time I open the workbook.

Thanks
Hank

--

Dave Peterson

--

Dave Peterson

Dave,

After many hours, I think I have found the problem. But, I do not
understand it??

When I save a "workspace" for the workbook on my desk top the freeze pane
information is lost when I open the file.

If I open excel, then open the file, the freeze pane information is there.
I can copy a shortcut to my desk top and open the file with freeze pane in
place.

Any idea why the workspace removes the freeze panes?

Thanks
Hank
"Dave Peterson" wrote in message
...
Are you sure that the freeze panes is being lost?

Next time, check to see if you see windows|Freeze panes or
windows|Unfreeze
panes.

If you see unfreeze, then maybe the user didn't put the freeze in the
correct
location.

If the data is filtered, then the freeze panes is applied, the user could
have
put the freeze panes in the wrong location.

I put 1 to 20 in A1:A20.

Then I filtered to show the values 5. I selected A6 and hit
window|freeze
panes.

Instead of making row 1 always visible, I made rows 1:5 always visible (I
had to
show all the data to see that freeze panes line).

If the user does this where the first 200 rows are hidden, it can cause a
problem when data|filter|show all is used.

======
If that's not the cause, set your freeze panes.
Save the workbook.
Close excel

Start excel in safe mode
windows start button|Run
excel /safe

file|open yourfilename.xls

And see if things work ok. If they do this way, then you could have a
"helpful"
macro that's removing that freeze panes.

Hank wrote:

Dave,

Yes, I am saving as xls. All other changes to the workbook saved -
except
the freeze pane.

As I asked earlier, could the fact that the row I am trying to freeze
also
has auto filter have anything to do with it?
I have found out if I remove auto filter the freeze pane does save.

I really need the auto filter kept. Is there a work around?

Thanks
Hank

"Dave Peterson" wrote in message
...
And you are saving the workbook as a normal workbook (*.xls)--not a
text
file
(like .prn or .csv), right?

Hank wrote:

In Excel 2003 I would like to Freeze the header row on each worksheet
and
have this "Freeze Pane" save when the workbook is closed.

Should the Freeze pane save? If not, is there a way to do this so the
header rows are always visible. I can indicate which rows I want to
print
at the top of each page with page setup. I'm trying to keep from
haveing
to
freeze pane each time I open the workbook.

Thanks
Hank

--

Dave Peterson

--

Dave Peterson

I've never used workspace, but I do remember seeing posts that somethings get
lost when they're used.

You may want to try searching google for freeze panes and workspace.

It looks like freeze panes and grid lines are a problem when you use workspaces
(and some others, too).



Hank wrote:

Dave,

After many hours, I think I have found the problem. But, I do not
understand it??

When I save a "workspace" for the workbook on my desk top the freeze pane
information is lost when I open the file.

If I open excel, then open the file, the freeze pane information is there.
I can copy a shortcut to my desk top and open the file with freeze pane in
place.

Any idea why the workspace removes the freeze panes?

Thanks
Hank
"Dave Peterson" wrote in message
...
Are you sure that the freeze panes is being lost?

Next time, check to see if you see windows|Freeze panes or
windows|Unfreeze
panes.

If you see unfreeze, then maybe the user didn't put the freeze in the
correct
location.

If the data is filtered, then the freeze panes is applied, the user could
have
put the freeze panes in the wrong location.

I put 1 to 20 in A1:A20.

Then I filtered to show the values 5. I selected A6 and hit
window|freeze
panes.

Instead of making row 1 always visible, I made rows 1:5 always visible (I
had to
show all the data to see that freeze panes line).

If the user does this where the first 200 rows are hidden, it can cause a
problem when data|filter|show all is used.

======
If that's not the cause, set your freeze panes.
Save the workbook.
Close excel

Start excel in safe mode
windows start button|Run
excel /safe

file|open yourfilename.xls

And see if things work ok. If they do this way, then you could have a
"helpful"
macro that's removing that freeze panes.

Hank wrote:

Dave,

Yes, I am saving as xls. All other changes to the workbook saved -
except
the freeze pane.

As I asked earlier, could the fact that the row I am trying to freeze
also
has auto filter have anything to do with it?
I have found out if I remove auto filter the freeze pane does save.

I really need the auto filter kept. Is there a work around?

Thanks
Hank

"Dave Peterson" wrote in message
...
And you are saving the workbook as a normal workbook (*.xls)--not a
text
file
(like .prn or .csv), right?

Hank wrote:

In Excel 2003 I would like to Freeze the header row on each worksheet
and
have this "Freeze Pane" save when the workbook is closed.

Should the Freeze pane save? If not, is there a way to do this so the
header rows are always visible. I can indicate which rows I want to
print
at the top of each page with page setup. I'm trying to keep from
haveing
to
freeze pane each time I open the workbook.

Thanks
Hank

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson