• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 381
  • Last Modified:

Graphics created in Excel 2003 is extremely slow in Excel 2007 and will hang

We are required to review a sheet of detailed graphics within Excel.  Most of us have upgraded to Excel 2007 and opening the file with the graphics takes 10 to 15 minutes.  Moving objects around in 2007 takes a long time or will cause the program to hang.
We opened the same file within Excel 2003 in a few seconds and the objects can be manipulated immediately with ease.
I tried to convert the file to .xlsx format but it does not remedy the situation.
We would certainly appreciate advise on this so we don't have to go back to 2003.
Thanks!
Ernie Adsett
0
ErnieA
Asked:
ErnieA
  • 5
  • 3
1 Solution
 
GlennHarrisCommented:
Just a random thought, after installing Excel or Office 2007 did you Update the programs (Office button, Excel Options, Resources, Check for Updates?
0
 
ErnieAAuthor Commented:
I wish that this would work but it didn't.
Just one more try at this question with the points increased.

Ernie
0
 
GlennHarrisCommented:
That is not normal behavior. While not an optimal solutions, what I'd do is re-create one of the 2003 files with a new clean 2007 workbook by copy/pasting the images; If the new 2007 xlsx workbook is slow it may indicate your computers are too old to run office 2007; Check the minimum system requirements and double them for safety. http://office.microsoft.com/en-us/products/HA101668651033.aspx
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
ErnieAAuthor Commented:
Hi Glenn
Thanks for the comment.   My computer is new and is quite capable.  

Ernie
0
 
GlennHarrisCommented:
And what happened when you recreate the workbook as a new 2007 file by copy/pasting the images? Another thought about images, if 300dpi and 8x10 your xl file may be too large; Microsoft recommends files should not exceed 32mb; I've gotten up to 60mb but those workbooks tend to crash/lock up more often.
0
 
GlennHarrisCommented:
If you're on a network this is more likely a network protocol issue w/ 2007; It could also be an antivirus conflict issue.
0
 
ErnieAAuthor Commented:
I read in another place that Excel 2003 is much faster than 2007 so I have reinstalled 2003 and it works fine. So much for progress.
This is the second question that I have not been able to get answered satisfactorily on this site,

Thanks for your help!!

Ernie
0
 
GlennHarrisCommented:
Well Ernie, sorry to hear, but in a collaboration problem solving environment, you have not been very helpful in terms of resolving the problem; I suggested you try recreating the workbook and you did not respond to that question. I suggested a network protocol issue and you did not provide any additional info. That said, I have no problem opening graphics intensive Excel 2003 spreadsheets in the Excel 2007 version on any of my multiple computers, so it must be an issue unique to your computers and their configuration. Best of luck.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now