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
ErnieAAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.