James has attended:
Upgrade to Office 2007 course
Slow worksheets after upgrade?
Hi there,
We have a worksheet with a lot of formulas in which works at a normal speed in 2003, but in 2007 is painfully painfully slow...it even 'draws' all the rows in front of your eyes!
We have tried a repair of the file, and also saving it out as a .xlsx instead of .xls
Any further suggestions would be greatfully received!
Thanks
RE: Slow worksheets after upgrade?
Hi James
Thanks for the question
This could have a number of possible solution, and it is hard to be specific without seeing the file. There is one posible solution that is beyond thescope of the forum, but I enclose a link that details the steps you need to follow to implement this
http://www.jpt-solutions.co.uk/2008/09/excel-2007-slow-opening-excel-2003-spreadsheets.html
Hope this helps
Regards
Stephen
RE: Slow worksheets after upgrade?
Thanks for this, but sadly this hasn't helped.
I'd be happy to send the file itself if that was of use, but would not be able to post it publically.
Thanks again,
James
RE: Slow worksheets after upgrade?
Hi James
Sorry for the delay in responding, but I have been on leave.
Feel free to send me the workbook, and I will take a look at it.
My email is sw@stl-training.co.uk
Regards
Stephen
