Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When I freeze windows on a workbook, additional copies are "viewable" from
the taskbar. Each time I freeze window another version appears. The name of the "views" are the actual filename suffixed with ":n" as follows: filename.ext:1 filename.ext:2 This is very annoying for a number of reasons and I want to turn it off. Any ideas? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
These windows aren't from Freezing panes. But they are from another option
under Window (on the menubar). Window|new window If you want to get rid of one of those windows, you can select the window to close and hit ctrl-w. Then save the workbook. If Window|Freeze panes actually does create these windows, then you could try resetting the toolbar: tools|customize|toolbars tab|select worksheet menu bar and click the Reset button (any customized changes to that toolbar will be lost and have to be recreated.) dgaex001 wrote: When I freeze windows on a workbook, additional copies are "viewable" from the taskbar. Each time I freeze window another version appears. The name of the "views" are the actual filename suffixed with ":n" as follows: filename.ext:1 filename.ext:2 This is very annoying for a number of reasons and I want to turn it off. Any ideas? -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you Dave, you are right, the window|new window is true and the Ctl-W
works to kill it. But I never use that function, and I confimed that mine are coming from the freeze funciton. Try this: Create a clean workbook. (Open excel to a blank sheet) Fill in a few cells in adjacent rows/cols Freeze window and scroll around. nothing happens. Unfreeze windows - see if you get a second "view". (book1.xls:2 and book1.xls:1) You can get rid of them by closing all of them with :1 being the last one closed, or Ctl-w works here also. But, is there any way to disable this "feature"? "Dave Peterson" wrote: These windows aren't from Freezing panes. But they are from another option under Window (on the menubar). Window|new window If you want to get rid of one of those windows, you can select the window to close and hit ctrl-w. Then save the workbook. If Window|Freeze panes actually does create these windows, then you could try resetting the toolbar: tools|customize|toolbars tab|select worksheet menu bar and click the Reset button (any customized changes to that toolbar will be lost and have to be recreated.) dgaex001 wrote: When I freeze windows on a workbook, additional copies are "viewable" from the taskbar. Each time I freeze window another version appears. The name of the "views" are the actual filename suffixed with ":n" as follows: filename.ext:1 filename.ext:2 This is very annoying for a number of reasons and I want to turn it off. Any ideas? -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It didn't work that way for me.
Did you try resetting the toolbar (from the first post)? dgaex001 wrote: Thank you Dave, you are right, the window|new window is true and the Ctl-W works to kill it. But I never use that function, and I confimed that mine are coming from the freeze funciton. Try this: Create a clean workbook. (Open excel to a blank sheet) Fill in a few cells in adjacent rows/cols Freeze window and scroll around. nothing happens. Unfreeze windows - see if you get a second "view". (book1.xls:2 and book1.xls:1) You can get rid of them by closing all of them with :1 being the last one closed, or Ctl-w works here also. But, is there any way to disable this "feature"? "Dave Peterson" wrote: These windows aren't from Freezing panes. But they are from another option under Window (on the menubar). Window|new window If you want to get rid of one of those windows, you can select the window to close and hit ctrl-w. Then save the workbook. If Window|Freeze panes actually does create these windows, then you could try resetting the toolbar: tools|customize|toolbars tab|select worksheet menu bar and click the Reset button (any customized changes to that toolbar will be lost and have to be recreated.) dgaex001 wrote: When I freeze windows on a workbook, additional copies are "viewable" from the taskbar. Each time I freeze window another version appears. The name of the "views" are the actual filename suffixed with ":n" as follows: filename.ext:1 filename.ext:2 This is very annoying for a number of reasons and I want to turn it off. Any ideas? -- Dave Peterson -- Dave Peterson |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hmm, the reset of the menu bar had no effect. I reset from the toolbar tab
and the options tab. Looks like I may be stuck with this.... "Dave Peterson" wrote: It didn't work that way for me. Did you try resetting the toolbar (from the first post)? dgaex001 wrote: Thank you Dave, you are right, the window|new window is true and the Ctl-W works to kill it. But I never use that function, and I confimed that mine are coming from the freeze funciton. Try this: Create a clean workbook. (Open excel to a blank sheet) Fill in a few cells in adjacent rows/cols Freeze window and scroll around. nothing happens. Unfreeze windows - see if you get a second "view". (book1.xls:2 and book1.xls:1) You can get rid of them by closing all of them with :1 being the last one closed, or Ctl-w works here also. But, is there any way to disable this "feature"? "Dave Peterson" wrote: These windows aren't from Freezing panes. But they are from another option under Window (on the menubar). Window|new window If you want to get rid of one of those windows, you can select the window to close and hit ctrl-w. Then save the workbook. If Window|Freeze panes actually does create these windows, then you could try resetting the toolbar: tools|customize|toolbars tab|select worksheet menu bar and click the Reset button (any customized changes to that toolbar will be lost and have to be recreated.) dgaex001 wrote: When I freeze windows on a workbook, additional copies are "viewable" from the taskbar. Each time I freeze window another version appears. The name of the "views" are the actual filename suffixed with ":n" as follows: filename.ext:1 filename.ext:2 This is very annoying for a number of reasons and I want to turn it off. Any ideas? -- Dave Peterson -- Dave Peterson |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you close excel and reopen in Safe mode...
close excel windows start button|run excel /safe and hit enter Do you still have the same trouble? dgaex001 wrote: Hmm, the reset of the menu bar had no effect. I reset from the toolbar tab and the options tab. Looks like I may be stuck with this.... "Dave Peterson" wrote: It didn't work that way for me. Did you try resetting the toolbar (from the first post)? dgaex001 wrote: Thank you Dave, you are right, the window|new window is true and the Ctl-W works to kill it. But I never use that function, and I confimed that mine are coming from the freeze funciton. Try this: Create a clean workbook. (Open excel to a blank sheet) Fill in a few cells in adjacent rows/cols Freeze window and scroll around. nothing happens. Unfreeze windows - see if you get a second "view". (book1.xls:2 and book1.xls:1) You can get rid of them by closing all of them with :1 being the last one closed, or Ctl-w works here also. But, is there any way to disable this "feature"? "Dave Peterson" wrote: These windows aren't from Freezing panes. But they are from another option under Window (on the menubar). Window|new window If you want to get rid of one of those windows, you can select the window to close and hit ctrl-w. Then save the workbook. If Window|Freeze panes actually does create these windows, then you could try resetting the toolbar: tools|customize|toolbars tab|select worksheet menu bar and click the Reset button (any customized changes to that toolbar will be lost and have to be recreated.) dgaex001 wrote: When I freeze windows on a workbook, additional copies are "viewable" from the taskbar. Each time I freeze window another version appears. The name of the "views" are the actual filename suffixed with ":n" as follows: filename.ext:1 filename.ext:2 This is very annoying for a number of reasons and I want to turn it off. Any ideas? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel should have multiple window splits . | Excel Worksheet Functions | |||
Multiple Spreadsheets Opening in Same Window | Excel Discussion (Misc queries) | |||
Clicking on restore window button changing the freeze pane in exce | Excel Discussion (Misc queries) | |||
Can I freeze multiple rows? | Excel Discussion (Misc queries) | |||
Advanced Window Split & Freeze Question | Excel Worksheet Functions |