When I freeze windows on a workbook, additional copies are quot;viewablequot; from
the taskbar. Each time I freeze window another version appears. The name of
the quot;viewsquot; are the actual filename suffixed with quot;:nquot; 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?
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:
gt;
gt; When I freeze windows on a workbook, additional copies are quot;viewablequot; from
gt; the taskbar. Each time I freeze window another version appears. The name of
gt; the quot;viewsquot; are the actual filename suffixed with quot;:nquot; as follows:
gt;
gt; filename.ext:1
gt; filename.ext:2
gt;
gt; This is very annoying for a number of reasons and I want to turn it off. Any
gt; ideas?
--
Dave Peterson
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 quot;viewquot;. (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 quot;featurequot;?
quot;Dave Petersonquot; wrote:
gt; These windows aren't from Freezing panes. But they are from another option
gt; under Window (on the menubar).
gt;
gt; Window|new window
gt;
gt; If you want to get rid of one of those windows, you can select the window to
gt; close and hit ctrl-w.
gt;
gt; Then save the workbook.
gt;
gt; If Window|Freeze panes actually does create these windows, then you could try
gt; resetting the toolbar:
gt;
gt; tools|customize|toolbars tab|select worksheet menu bar
gt; and click the Reset button
gt;
gt; (any customized changes to that toolbar will be lost and have to be recreated.)
gt;
gt; dgaex001 wrote:
gt; gt;
gt; gt; When I freeze windows on a workbook, additional copies are quot;viewablequot; from
gt; gt; the taskbar. Each time I freeze window another version appears. The name of
gt; gt; the quot;viewsquot; are the actual filename suffixed with quot;:nquot; as follows:
gt; gt;
gt; gt; filename.ext:1
gt; gt; filename.ext:2
gt; gt;
gt; gt; This is very annoying for a number of reasons and I want to turn it off. Any
gt; gt; ideas?
gt;
gt; --
gt;
gt; Dave Peterson
gt;
It didn't work that way for me.
Did you try resetting the toolbar (from the first post)?dgaex001 wrote:
gt;
gt; Thank you Dave, you are right, the window|new window is true and the Ctl-W
gt; works to kill it. But I never use that function, and I confimed that mine are
gt; coming from the freeze funciton.
gt; Try this:
gt; Create a clean workbook. (Open excel to a blank sheet)
gt; Fill in a few cells in adjacent rows/cols
gt; Freeze window and scroll around. nothing happens.
gt; Unfreeze windows - see if you get a second quot;viewquot;. (book1.xls:2 and
gt; book1.xls:1)
gt; You can get rid of them by closing all of them with :1 being the last one
gt; closed, or Ctl-w works here also.
gt; But, is there any way to disable this quot;featurequot;?
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; These windows aren't from Freezing panes. But they are from another option
gt; gt; under Window (on the menubar).
gt; gt;
gt; gt; Window|new window
gt; gt;
gt; gt; If you want to get rid of one of those windows, you can select the window to
gt; gt; close and hit ctrl-w.
gt; gt;
gt; gt; Then save the workbook.
gt; gt;
gt; gt; If Window|Freeze panes actually does create these windows, then you could try
gt; gt; resetting the toolbar:
gt; gt;
gt; gt; tools|customize|toolbars tab|select worksheet menu bar
gt; gt; and click the Reset button
gt; gt;
gt; gt; (any customized changes to that toolbar will be lost and have to be recreated.)
gt; gt;
gt; gt; dgaex001 wrote:
gt; gt; gt;
gt; gt; gt; When I freeze windows on a workbook, additional copies are quot;viewablequot; from
gt; gt; gt; the taskbar. Each time I freeze window another version appears. The name of
gt; gt; gt; the quot;viewsquot; are the actual filename suffixed with quot;:nquot; as follows:
gt; gt; gt;
gt; gt; gt; filename.ext:1
gt; gt; gt; filename.ext:2
gt; gt; gt;
gt; gt; gt; This is very annoying for a number of reasons and I want to turn it off. Any
gt; gt; gt; ideas?
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;
--
Dave Peterson
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....
quot;Dave Petersonquot; wrote:
gt; It didn't work that way for me.
gt;
gt; Did you try resetting the toolbar (from the first post)?
gt;
gt;
gt; dgaex001 wrote:
gt; gt;
gt; gt; Thank you Dave, you are right, the window|new window is true and the Ctl-W
gt; gt; works to kill it. But I never use that function, and I confimed that mine are
gt; gt; coming from the freeze funciton.
gt; gt; Try this:
gt; gt; Create a clean workbook. (Open excel to a blank sheet)
gt; gt; Fill in a few cells in adjacent rows/cols
gt; gt; Freeze window and scroll around. nothing happens.
gt; gt; Unfreeze windows - see if you get a second quot;viewquot;. (book1.xls:2 and
gt; gt; book1.xls:1)
gt; gt; You can get rid of them by closing all of them with :1 being the last one
gt; gt; closed, or Ctl-w works here also.
gt; gt; But, is there any way to disable this quot;featurequot;?
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; These windows aren't from Freezing panes. But they are from another option
gt; gt; gt; under Window (on the menubar).
gt; gt; gt;
gt; gt; gt; Window|new window
gt; gt; gt;
gt; gt; gt; If you want to get rid of one of those windows, you can select the window to
gt; gt; gt; close and hit ctrl-w.
gt; gt; gt;
gt; gt; gt; Then save the workbook.
gt; gt; gt;
gt; gt; gt; If Window|Freeze panes actually does create these windows, then you could try
gt; gt; gt; resetting the toolbar:
gt; gt; gt;
gt; gt; gt; tools|customize|toolbars tab|select worksheet menu bar
gt; gt; gt; and click the Reset button
gt; gt; gt;
gt; gt; gt; (any customized changes to that toolbar will be lost and have to be recreated.)
gt; gt; gt;
gt; gt; gt; dgaex001 wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; When I freeze windows on a workbook, additional copies are quot;viewablequot; from
gt; gt; gt; gt; the taskbar. Each time I freeze window another version appears. The name of
gt; gt; gt; gt; the quot;viewsquot; are the actual filename suffixed with quot;:nquot; as follows:
gt; gt; gt; gt;
gt; gt; gt; gt; filename.ext:1
gt; gt; gt; gt; filename.ext:2
gt; gt; gt; gt;
gt; gt; gt; gt; This is very annoying for a number of reasons and I want to turn it off. Any
gt; gt; gt; gt; ideas?
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;
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:
gt;
gt; Hmm, the reset of the menu bar had no effect. I reset from the toolbar tab
gt; and the options tab. Looks like I may be stuck with this....
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; It didn't work that way for me.
gt; gt;
gt; gt; Did you try resetting the toolbar (from the first post)?
gt; gt;
gt; gt;
gt; gt; dgaex001 wrote:
gt; gt; gt;
gt; gt; gt; Thank you Dave, you are right, the window|new window is true and the Ctl-W
gt; gt; gt; works to kill it. But I never use that function, and I confimed that mine are
gt; gt; gt; coming from the freeze funciton.
gt; gt; gt; Try this:
gt; gt; gt; Create a clean workbook. (Open excel to a blank sheet)
gt; gt; gt; Fill in a few cells in adjacent rows/cols
gt; gt; gt; Freeze window and scroll around. nothing happens.
gt; gt; gt; Unfreeze windows - see if you get a second quot;viewquot;. (book1.xls:2 and
gt; gt; gt; book1.xls:1)
gt; gt; gt; You can get rid of them by closing all of them with :1 being the last one
gt; gt; gt; closed, or Ctl-w works here also.
gt; gt; gt; But, is there any way to disable this quot;featurequot;?
gt; gt; gt;
gt; gt; gt; quot;Dave Petersonquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; These windows aren't from Freezing panes. But they are from another option
gt; gt; gt; gt; under Window (on the menubar).
gt; gt; gt; gt;
gt; gt; gt; gt; Window|new window
gt; gt; gt; gt;
gt; gt; gt; gt; If you want to get rid of one of those windows, you can select the window to
gt; gt; gt; gt; close and hit ctrl-w.
gt; gt; gt; gt;
gt; gt; gt; gt; Then save the workbook.
gt; gt; gt; gt;
gt; gt; gt; gt; If Window|Freeze panes actually does create these windows, then you could try
gt; gt; gt; gt; resetting the toolbar:
gt; gt; gt; gt;
gt; gt; gt; gt; tools|customize|toolbars tab|select worksheet menu bar
gt; gt; gt; gt; and click the Reset button
gt; gt; gt; gt;
gt; gt; gt; gt; (any customized changes to that toolbar will be lost and have to be recreated.)
gt; gt; gt; gt;
gt; gt; gt; gt; dgaex001 wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; When I freeze windows on a workbook, additional copies are quot;viewablequot; from
gt; gt; gt; gt; gt; the taskbar. Each time I freeze window another version appears. The name of
gt; gt; gt; gt; gt; the quot;viewsquot; are the actual filename suffixed with quot;:nquot; as follows:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; filename.ext:1
gt; gt; gt; gt; gt; filename.ext:2
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; This is very annoying for a number of reasons and I want to turn it off. Any
gt; gt; gt; gt; gt; ideas?
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt;
gt; gt; gt; gt; Dave Peterson
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;
--
Dave Peterson
- Apr 21 Sat 2007 20:37
freeze window creates multiple quot;viewsquot; suffixed with quot;:nquot;
close
全站熱搜
留言列表
發表留言