ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel file opens with a blank screen (https://www.excelbanter.com/excel-discussion-misc-queries/22460-excel-file-opens-blank-screen.html)

Meagan

Excel file opens with a blank screen
 
I have an excel file with a few worksheets. Sometimes (But this does not
happen every time) after I run a macro that takes data from other files and
puts it onto a worksheet in the current file, after I save and close the
current file and then reopen the file, it comes up blank. I can still view
my vb code, but I cannot see the actual spreadsheets unless I go to
View--Full screen and then reduce the view with the minimize icon on the
little toolbar that pops up. What really makes this odd, is that a friend in
another lab can run the macro and open the file at his place with no
problems. I sent it to someone else in my office and they also could not
open it. Our office has Excel 2002 with SP-3 and the other office with EXCEL
2002 SP3 works OK. Has anyone seen this before and is there something I can
do besides having to go into View to reset it? Would installing SP-3 make a
difference?
Thanks for any help.




Meagan

OOops..WE have SP2 and the other office where it works has SP3...sorry about
the confusion.


"Meagan" wrote in message
...
I have an excel file with a few worksheets. Sometimes (But this does not
happen every time) after I run a macro that takes data from other files and
puts it onto a worksheet in the current file, after I save and close the
current file and then reopen the file, it comes up blank. I can still view
my vb code, but I cannot see the actual spreadsheets unless I go to
View--Full screen and then reduce the view with the minimize icon on the
little toolbar that pops up. What really makes this odd, is that a friend
in another lab can run the macro and open the file at his place with no
problems. I sent it to someone else in my office and they also could not
open it. Our office has Excel 2002 with SP-3 and the other office with
EXCEL 2002 SP3 works OK. Has anyone seen this before and is there something
I can do besides having to go into View to reset it? Would installing SP-3
make a difference?
Thanks for any help.







All times are GMT +1. The time now is 05:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com