close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()