#1   Report Post  
Posted to microsoft.public.excel.misc
hmm hmm is offline
external usenet poster
 
Posts: 175
Default Multiple-window view

I view my worksheet in two tiled windows, and save the view. When I recall
the view, I only get one of the windows back.

How do I save a view to recall all the windows?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,173
Default Multiple-window view

How about filesave as workspace...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"hmm" wrote in message
...
I view my worksheet in two tiled windows, and save the view. When I recall
the view, I only get one of the windows back.

How do I save a view to recall all the windows?


  #3   Report Post  
Posted to microsoft.public.excel.misc
hmm hmm is offline
external usenet poster
 
Posts: 175
Default Multiple-window view

Thanks Nick.

There is problem with recalling a workspace: instead of rearranging the
open workbook, Excel tells me it can't open two documents with the same name.
I have to close the workbook just to view it the way I want! I was hoping
for a better solution; I guess this is it, unless you know a way around this
problem.

"Nick Hodge" wrote:

How about filesave as workspace...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"hmm" wrote in message
...
I view my worksheet in two tiled windows, and save the view. When I recall
the view, I only get one of the windows back.

How do I save a view to recall all the windows?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,173
Default Multiple-window view

Are you viewing two windows of the same workbook? (Via WindowNew window and
Windowarrange...). This should only then open one 'view' of the current
workbook in two windows. Is that not what you need?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"hmm" wrote in message
...
Thanks Nick.

There is problem with recalling a workspace: instead of rearranging the
open workbook, Excel tells me it can't open two documents with the same
name.
I have to close the workbook just to view it the way I want! I was hoping
for a better solution; I guess this is it, unless you know a way around
this
problem.

"Nick Hodge" wrote:

How about filesave as workspace...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"hmm" wrote in message
...
I view my worksheet in two tiled windows, and save the view. When I
recall
the view, I only get one of the windows back.

How do I save a view to recall all the windows?



  #5   Report Post  
Posted to microsoft.public.excel.misc
hmm hmm is offline
external usenet poster
 
Posts: 175
Default Multiple-window view

Yes, that is what I am doing; yes, it is what I need. But if the workbook is
already open, I must close it before opening the workspace. I was looking to
avoid that inconvenience, if possible.

"Nick Hodge" wrote:

Are you viewing two windows of the same workbook? (Via WindowNew window and
Windowarrange...). This should only then open one 'view' of the current
workbook in two windows. Is that not what you need?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"hmm" wrote in message
...
Thanks Nick.

There is problem with recalling a workspace: instead of rearranging the
open workbook, Excel tells me it can't open two documents with the same
name.
I have to close the workbook just to view it the way I want! I was hoping
for a better solution; I guess this is it, unless you know a way around
this
problem.

"Nick Hodge" wrote:

How about filesave as workspace...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"hmm" wrote in message
...
I view my worksheet in two tiled windows, and save the view. When I
recall
the view, I only get one of the windows back.

How do I save a view to recall all the windows?




  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,173
Default Multiple-window view

Does it not just open the way you close it? I fear I'm missing something
here

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"hmm" wrote in message
...
Yes, that is what I am doing; yes, it is what I need. But if the workbook
is
already open, I must close it before opening the workspace. I was looking
to
avoid that inconvenience, if possible.

"Nick Hodge" wrote:

Are you viewing two windows of the same workbook? (Via WindowNew window
and
Windowarrange...). This should only then open one 'view' of the current
workbook in two windows. Is that not what you need?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"hmm" wrote in message
...
Thanks Nick.

There is problem with recalling a workspace: instead of rearranging
the
open workbook, Excel tells me it can't open two documents with the same
name.
I have to close the workbook just to view it the way I want! I was
hoping
for a better solution; I guess this is it, unless you know a way around
this
problem.

"Nick Hodge" wrote:

How about filesave as workspace...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"hmm" wrote in message
...
I view my worksheet in two tiled windows, and save the view. When I
recall
the view, I only get one of the windows back.

How do I save a view to recall all the windows?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I view more than one tab at a time, within a given workshee JoeOvercoat Excel Discussion (Misc queries) 2 September 2nd 06 11:42 PM
Same view for multiple sheets killa47 Excel Discussion (Misc queries) 3 December 2nd 05 01:11 PM
How can I see multiple workbooks in the taskbar? Tried the Window. marg709 Excel Discussion (Misc queries) 0 March 23rd 05 09:53 PM
There is no way to view multiple sheets from one workbook kstub Excel Discussion (Misc queries) 3 December 17th 04 08:55 PM
view multiple sheets from same workbook mangates Excel Worksheet Functions 2 November 8th 04 06:08 PM


All times are GMT +1. The time now is 05:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"