![]() |
Opening hidden ghosts
I've got a ghost in an excel file. When I open the file it is automatically
hidden, i.e. you have to go to Window-Unhide to see that it is open, and when I do there are two copies. To summarise, when I try to open this excel file it always opens two copies of the file and both are hidden. Any help appreciated |
Opening hidden ghosts
Nel post
*havenlad* ha scritto: I've got a ghost in an excel file. When I open the file it is automatically hidden, i.e. you have to go to Window-Unhide to see that it is open, and when I do there are two copies. To summarise, when I try to open this excel file it always opens two copies of the file and both are hidden. Any help appreciated Try with this: Open your file, unhide the two windows, close one of the two windows, then save your file and close it. Try to open it again. -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Opening hidden ghosts
Hi,
try to see if you do not have any Auto_open function in VBA on this WS, press ALT+F11 to see it. HTH Regards from Brazil Marcelo "havenlad" escreveu: I've got a ghost in an excel file. When I open the file it is automatically hidden, i.e. you have to go to Window-Unhide to see that it is open, and when I do there are two copies. To summarise, when I try to open this excel file it always opens two copies of the file and both are hidden. Any help appreciated |
Opening hidden ghosts
And it's not two copies of the file--it's two windows or views into a single
workbook. Debra Dalgleish has instructions (with pictures!): http://www.contextures.com/xlfaqApp.html#TwoWindows havenlad wrote: I've got a ghost in an excel file. When I open the file it is automatically hidden, i.e. you have to go to Window-Unhide to see that it is open, and when I do there are two copies. To summarise, when I try to open this excel file it always opens two copies of the file and both are hidden. Any help appreciated -- Dave Peterson |
Opening hidden ghosts
Thanks - so simple but it worked
"Franz Verga" wrote: Nel post *havenlad* ha scritto: I've got a ghost in an excel file. When I open the file it is automatically hidden, i.e. you have to go to Window-Unhide to see that it is open, and when I do there are two copies. To summarise, when I try to open this excel file it always opens two copies of the file and both are hidden. Any help appreciated Try with this: Open your file, unhide the two windows, close one of the two windows, then save your file and close it. Try to open it again. -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
All times are GMT +1. The time now is 04:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com