Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening an Excel File | Excel Discussion (Misc queries) | |||
Having a different Excel file on Each Screen (Multiple Monitors) | Excel Discussion (Misc queries) | |||
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) | |||
Excel file modification date | Excel Discussion (Misc queries) | |||
Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) |