Mickeyfinn
New Member
- Joined
- Feb 11, 2005
- Messages
- 9
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
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