The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Slow worksheets after upgrade?

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Slow worksheets after upgrade?

Resolved · Low Priority · Version 2007

ReplyFri 11 Jun 2010, 15:16Delegate James said...

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

For upcoming training course dates see: Pricing & availability

ReplyWed 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

ReplyWed 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

ReplyThu 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

Regards

Stephen

Excel articles

· What's In A Number? Make Figures Mean More Via Excel
· How To Create Formulas In Excel
· Create Contrasting Coloured Rows In Excel
· Baffled by custom number formatting in Excel?
· How To Use The Research Functionality In Excel 2010

Please browse our web site to find out more about
excel software training and other Microsoft training courses.

Excel tip:

Use the Format Painter to copy formatting more than once in Excel

The format painter tool provides a quick and easy way to copy formatting from one cell to another in Word.

The only problem is that if you click the Format Painter once to turn it on, you can only click and drag over a single cell or adjacent range of cells; then the Format Painter turns itself off automatically.

If you want to copy formatting to cells or groups of cells that are not adjacent to each other, double-click the Format Painter - this way you will be able to copy formatting to multiple cells.

When you have finished using Format Painter, press the Esc key or click on the Format Painter button once to turn it off.

View all Excel hints and tips

Taking The Office Home With You

The decision to allow employees to work from home could lead to happier workers as individuals are able to create a better balance of both work and lifestyle and thus increase productivity through a process of self-motivation. Find out how you can save thousands of pounds and take your business to the next level by offering home working as an option for your employees.

» Article: Managing teams remotely course

Is there a way that one can call a procedure in the program more than once using and if statement?

» Forum post: VBA intermediate

To move through all of your open documents press the control shift keys. This will move you through the documents one by one, every time you press this key combination.