Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 18th 05, 05:35 PM
Meagan
 
Posts: n/a
Default 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.




  #2   Report Post  
Old April 18th 05, 05:37 PM
Meagan
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening an Excel File jedi249 Excel Discussion (Misc queries) 5 April 16th 05 11:44 PM
Having a different Excel file on Each Screen (Multiple Monitors) Ralph Excel Discussion (Misc queries) 4 March 23rd 05 01:03 AM
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. PboB Excel Discussion (Misc queries) 3 March 16th 05 06:17 PM
Excel file modification date GROSNER Excel Discussion (Misc queries) 5 March 4th 05 01:19 AM
Using Jet to read excel file returns blank for last cell - sometim Ron Excel Discussion (Misc queries) 1 December 9th 04 08:21 AM


All times are GMT +1. The time now is 11:22 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017