Excel 2007 - anyone having reliability issues?
Jul 4, 2008 | 1:26 am
#1
Original Poster
Join Date: Jan 2003
Location: between DCA and BWI
Programs: SPG Gold, Hyatt Plat, UA Premier, Hilton Gold
Posts: 3,652
Excel 2007 - anyone having reliability issues?
It just took me 6 minutes to open a 20 mb Excel file - on a 3rd try . I am reasonably certain that the performance hit was due to Vista, but could Excel be to blame? Has anyone tried using Excel 07 with large spreadsheets on XP? Did you have any issues?
Jul 4, 2008 | 2:04 pm
#6
A FlyerTalk Posting Legend
Join Date: Apr 2001
Location: PSM
Posts: 69,232
Is it an excel 2007 or previous version file? Is excel configured to recalculate formulas automatically or not? Both of these things can contribute to the speed issue with opening the file. Trying once without AV enabled should pretty easily tell you if that's the problem. Ditto for disabling the automatic formula calculation (formula tab | calculation | automatic).
Also, is Excel already open or not? If not, does opening it up first speed the process notably? There may be issues with add-ins or other things slowing down the overall load process, though probably not 6 minutes worth.
Were the first two attempts actual failures or did you just get impatient? Do you have orphaned instances of excel.exe running?
Also, is Excel already open or not? If not, does opening it up first speed the process notably? There may be issues with add-ins or other things slowing down the overall load process, though probably not 6 minutes worth.
Were the first two attempts actual failures or did you just get impatient? Do you have orphaned instances of excel.exe running?
Jul 5, 2008 | 6:01 pm
#8
Original Poster
Join Date: Jan 2003
Location: between DCA and BWI
Programs: SPG Gold, Hyatt Plat, UA Premier, Hilton Gold
Posts: 3,652
The file was created using Excel 2003. Excel was set to recalculate formulas automatically, but disabling it didn't seem to make much of a difference. Disabling the antivirus also didn't affect the loading times significantly.
Regarding the first two attempts, first one was a failure and I got impatient with the second one - closed all orphaned instances before trying to open Excel again.
As far as Acrobat, I don't have it running. Using Sumatra PDF instead.
Regarding the first two attempts, first one was a failure and I got impatient with the second one - closed all orphaned instances before trying to open Excel again.
As far as Acrobat, I don't have it running. Using Sumatra PDF instead.
Is it an excel 2007 or previous version file? Is excel configured to recalculate formulas automatically or not? Both of these things can contribute to the speed issue with opening the file. Trying once without AV enabled should pretty easily tell you if that's the problem. Ditto for disabling the automatic formula calculation (formula tab | calculation | automatic).
Also, is Excel already open or not? If not, does opening it up first speed the process notably? There may be issues with add-ins or other things slowing down the overall load process, though probably not 6 minutes worth.
Were the first two attempts actual failures or did you just get impatient? Do you have orphaned instances of excel.exe running?
Also, is Excel already open or not? If not, does opening it up first speed the process notably? There may be issues with add-ins or other things slowing down the overall load process, though probably not 6 minutes worth.
Were the first two attempts actual failures or did you just get impatient? Do you have orphaned instances of excel.exe running?
Jul 6, 2008 | 11:56 am
#9
FlyerTalk Evangelist
Join Date: Jul 2003
Posts: 11,377
Jul 6, 2008 | 12:53 pm
#10
A FlyerTalk Posting Legend
Join Date: Apr 2001
Location: PSM
Posts: 69,232
The file was created using Excel 2003. Excel was set to recalculate formulas automatically, but disabling it didn't seem to make much of a difference. Disabling the antivirus also didn't affect the loading times significantly.
Regarding the first two attempts, first one was a failure and I got impatient with the second one - closed all orphaned instances before trying to open Excel again.
Regarding the first two attempts, first one was a failure and I got impatient with the second one - closed all orphaned instances before trying to open Excel again.
Is Excel slow to start if you are not also opening a document? How long does it take to load if Excel is already open?
Jul 6, 2008 | 3:21 pm
#11
Original Poster
Join Date: Jan 2003
Location: between DCA and BWI
Programs: SPG Gold, Hyatt Plat, UA Premier, Hilton Gold
Posts: 3,652
I had two Excel add-ins active and some others inactive. I disabled the active ones, and it seemed to get a little faster, although still very slow.
Saving the document as an Excel 07 file also didn't change anything . Excel is fast when I am not loading a document (or when I load a very small one) , but takes a LONG time to load larger file or to actually do anything with them . Just took over a minute to delete 3000 rows, each of which had 2-3 columns of data.
Opening Excel first, before loading the file doesn't make a difference.
Saving the document as an Excel 07 file also didn't change anything . Excel is fast when I am not loading a document (or when I load a very small one) , but takes a LONG time to load larger file or to actually do anything with them . Just took over a minute to delete 3000 rows, each of which had 2-3 columns of data.
Opening Excel first, before loading the file doesn't make a difference.
Jul 7, 2008 | 10:35 pm
#13
Join Date: Jun 2006
Location: VA - US
Programs: Anything and everything I can sign up for. At least the ones I can get some benefit from.
Posts: 141
Lord I hope not. I've had computer issues since last week and our IS dept just installed XP Pro Office 2007 on my system this afternoon. Haven't gotten to play with it yet.
With Micro$oft, failure is not an option............... it's fatihfully included in every package
Safe travels, err.... computer travels, err... that don't sound right either but you know what I mean
Tim
Jul 8, 2008 | 12:14 am
#14
Join Date: Sep 2002
Location: Hoboken, NJ; Pembroke Pines, FL
Programs: CO Gold, SPG Gold
Posts: 2,940
I've had no problems with Office 2007 since they upgraded me at work. The corporate technology crew set everything to save in the old formats, though.
Well, to tell the truth I have had a few problems with Outlook 2007, but I like it so much more than the old version that I spin it as problem-free because I think it has fewer problems than the 2003 version, on the whole.
Well, to tell the truth I have had a few problems with Outlook 2007, but I like it so much more than the old version that I spin it as problem-free because I think it has fewer problems than the 2003 version, on the whole.