Multiple-window view

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Are you viewing two windows of the same workbook? (Via Window>New window and
Window>arrange...). 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
(e-mail address removed)
www.nickhodge.co.uk
 
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.
 
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
(e-mail address removed)
www.nickhodge.co.uk
 
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.
 
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
(e-mail address removed)
www.nickhodge.co.uk
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

File view - full page 2
View two sheets alongside? 2
Viewing multiple worksheets 4
Excel 2007 "view side by Side" 10
xls:1 but no xls:2 1
Can't view Google Maps in 3D anymore? Here's the fix. 2
I can no longer 'drag and drop' text. 6
Still can't view multiple worksheets 1

Back
Top