Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I view more than one tab at a time, within a given workshee | Excel Discussion (Misc queries) | |||
Same view for multiple sheets | Excel Discussion (Misc queries) | |||
How can I see multiple workbooks in the taskbar? Tried the Window. | Excel Discussion (Misc queries) | |||
There is no way to view multiple sheets from one workbook | Excel Discussion (Misc queries) | |||
view multiple sheets from same workbook | Excel Worksheet Functions |