LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,173
Default Multiple-window view

Anytime you try to open two workbooks at the same time your options will be
limited, so if you mean can you save multiple views. Not that I am aware for
windows, although you can say views of filters, etc

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


"hmm" wrote in message
...
Suppose I save a workspace, with the multiple windows and whatever else.
After defining it, I continue to work on the same workbook. Now I want to
recall the saved workspace. If I try, Excel will tell me it cannot open
two
workbooks with the same name. Therefore, I must close the workbook every
time I want to see it from a different workspace perspective. This
constant
closing and re-opening is what I am trying to avoid, if there is any way
possible.

"Nick Hodge" wrote:

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?




 
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 02:20 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"