Slow calculation on 1 sheet only in workbook

[Mickeyfinn]

Any ideas as to why all of a sudden I have 1 particular sheet, in a workbook of 7 or so sheets, that has decided to calculate slow.
I know that it contains about 100 cells using Lookup but it has worked faster before I'm sure.
Also is there any other way of getting data from Access to a specific cell or cells in Excel other than what I have done by using 'Output to' an excel.xls sheet and then looking up the data in that to return on the specific cell or cells in my original workbook sheet.
many thanks in Advance for any help
Mick

 

[CraigM]

I’m not to sure about your speed problem, but 100 lookups shouldn’t make any discernable difference to calculation speed I wouldn’t think.

With your Access data, have you investigated (in Excel) Data>Import External Data>New Database Query. Select MS Access Database, and you can use MS Query to directly query your database from Excel. You just need to Refresh your query when needed, but (I think from memory) that you are prompted to do so when opening the workbook.

 

[Mickeyfinn]

Slow Calcs AGAIN

Firstly Thanks to Craig and Brian and others for replying, has been a lot of help although I've been learning more about everything else but havent solved my problem.
Am sorting out loads of Dynamic Name ranges to strink things up a bit but think from the advice I've had and reading the stuff on here that its something to do with this VOLATILE thing.
I'm sure I dont have anything volatile ie. Now() Today() etc. But how can I be sure and how can I correct it if there is. My Functions and formulars are all built in or from the toolbar menu and not in VBA as far as I know.
And I do have far more complicated and larger workbooks than this that don't do that bloody 'Calculation' thing in the bottom left corner.
So any ideas how I can stop or speed that up.
Thanks again
Mick

 

[Mickeyfinn]

Slow Calcs AGAIN

Firstly Thanks to Craig and Brian and others for replying, has been a lot of help although I've been learning more about everything else but havent solved my problem.
Am sorting out loads of Dynamic Name ranges to strink things up a bit but think from the advice I've had and reading the stuff on here that its something to do with this VOLATILE thing.
I'm sure I dont have anything volatile ie. Now() Today() etc. But how can I be sure and how can I correct it if there is. My Functions and formulars are all built in or from the toolbar menu and not in VBA as far as I know.
And I do have far more complicated and larger workbooks than this that don't do that bloody 'Calculation' thing in the bottom left corner.
So any ideas how I can stop or speed that up.
Thanks again
Mick

 

[Mickeyfinn]

Slow Calcs AGAIN

Firstly Thanks to Craig and Brian and others for replying, has been a lot of help although I've been learning more about everything else but havent solved my problem.
Am sorting out loads of Dynamic Name ranges to strink things up a bit but think from the advice I've had and reading the stuff on here that its something to do with this VOLATILE thing.
I'm sure I dont have anything volatile ie. Now() Today() etc. But how can I be sure and how can I correct it if there is. My Functions and formulars are all built in or from the toolbar menu and not in VBA as far as I know.
And I do have far more complicated and larger workbooks than this that don't do that bloody 'Calculation' thing in the bottom left corner.
So any ideas how I can stop or speed that up.
Thanks again
Mick
WHOOPS! Sorry about the double posting