Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi everyone,
I have a small problem with a workbook that I regularly send out to some of the people at my work. The workbook is not that complicated. Just a Pivot table and a Pivot graph with a few formating macros. Some times they cant seem to open the workbook. When they open it excel appeares blank and with no workbook open. I´ve found a way around this. When you start a new workbook in the same window and select "window - compare side bys side" the hidden workbook appeares. Has anyone ever seen anything like this? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hannes,
Is it listed under the Windows menu when it is not visible? If it is, may be it is open but it's positioned outside of the Excel window, but returns once you arrange the windows. NickHK "Hannes" wrote in message ... Hi everyone, I have a small problem with a workbook that I regularly send out to some of the people at my work. The workbook is not that complicated. Just a Pivot table and a Pivot graph with a few formating macros. Some times they cant seem to open the workbook. When they open it excel appeares blank and with no workbook open. I´ve found a way around this. When you start a new workbook in the same window and select "window - compare side bys side" the hidden workbook appeares. Has anyone ever seen anything like this? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Yes it is listed undir the windows menu, but I cant scroll or do anything to
find it. If I use the arrange function nothing happens. I can only find it by comparing it side by side with another workbook. "NickHK" wrote: Hannes, Is it listed under the Windows menu when it is not visible? If it is, may be it is open but it's positioned outside of the Excel window, but returns once you arrange the windows. NickHK "Hannes" wrote in message ... Hi everyone, I have a small problem with a workbook that I regularly send out to some of the people at my work. The workbook is not that complicated. Just a Pivot table and a Pivot graph with a few formating macros. Some times they cant seem to open the workbook. When they open it excel appeares blank and with no workbook open. I´ve found a way around this. When you start a new workbook in the same window and select "window - compare side bys side" the hidden workbook appeares. Has anyone ever seen anything like this? |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try Window / Arrange / Tiled and then maximise the sheet (but without
opening another sheet first). then save your file when you have done that. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Hannes" wrote in message ... Yes it is listed undir the windows menu, but I cant scroll or do anything to find it. If I use the arrange function nothing happens. I can only find it by comparing it side by side with another workbook. "NickHK" wrote: Hannes, Is it listed under the Windows menu when it is not visible? If it is, may be it is open but it's positioned outside of the Excel window, but returns once you arrange the windows. NickHK "Hannes" wrote in message ... Hi everyone, I have a small problem with a workbook that I regularly send out to some of the people at my work. The workbook is not that complicated. Just a Pivot table and a Pivot graph with a few formating macros. Some times they cant seem to open the workbook. When they open it excel appeares blank and with no workbook open. I´ve found a way around this. When you start a new workbook in the same window and select "window - compare side bys side" the hidden workbook appeares. Has anyone ever seen anything like this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
How do you program so that Workbook B cannot be open unless Workbook A is open? Plus I need to validation | Excel Programming |