Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze Pane Saving
In article , "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. If you mean should the view where you have one or more 'fixed' rows and/or columns save with the sheet, my experience is yes. If you mean something else, then please say :) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze Pane Saving
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze Pane Saving
Certainly should be saved with the workbook, but if you
don't make a change to the workbook then it would not be saved. Suggest you use File, Save to make sure it is saved. Freeze Panes for view and Repeat row/col headings for printing http://www.mvps.org/dmcritchie/excel/freeze.htm -- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Hank" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze Pane Saving
WindowFreeze Panes should save with the workbook.
Note: without VBA you can't "Freeze Panes" on every sheet at once. Must be done individually as it is a Window-only setting. Gord Dibben MS Excel MVP On Thu, 28 Jun 2007 20:55:03 -0500, "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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze Pane Saving
Bruce, thanks for the reply.
Yes, I do mean saving the view and the freeze pane. This workbook has auto filter on each column. This seems to have something to do with it. Other workbooks do save the freeze pane view. Is there a way to have auto filter and save the freeze pane view? Thanks again Hank "Bruce Sinclair" wrote in message ... In article , "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. If you mean should the view where you have one or more 'fixed' rows and/or columns save with the sheet, my experience is yes. If you mean something else, then please say :) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze Pane Saving
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze Pane Saving
Hank, the Spreadsheet Assistant, http://www.add-ins.com/assistnt.htm, has a
feature in it that will set the freeze pane and zoom on all selected sheets. The only restriction is that the to top left cell and the freeze pane cell must be visible so that freeze panes can be set. Bob Flanagan Macro Systems 144 Dewberry Drive Hockessin, Delaware, U.S. 19707 Phone: 302-234-9857, cell 302-584-1771 http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Hank" wrote in message ... 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze Pane Saving
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 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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze Pane Saving
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 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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze Pane Saving
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 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 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Freeze Pane Saving
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Freeze Pane problem | Excel Discussion (Misc queries) | |||
Freeze pane | Excel Worksheet Functions | |||
Freeze pane | Excel Discussion (Misc queries) | |||
Freeze Pane Border | Excel Discussion (Misc queries) | |||
Freeze pane | Excel Worksheet Functions |