98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Slow worksheets after upgrade?
Slow worksheets after upgrade?
Resolved · Low Priority · Version 2007
Fri 11 Jun 2010, 15:16Delegate James said...
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
Wed 16 Jun 2010, 13:43Trainer Stephen said...
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
Wed 16 Jun 2010, 13:49Delegate James said...
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
Thu 1 Jul 2010, 09:37Trainer Stephen said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding up rows or columns without seeing formulasHighlight a column or row and click the Autosum button. This gives you your answer without showing the formula. |
