Goal Seek Speed

[longsabre]

I have a client with an extremely large workbook and when they run a goal seek it can sometimes up to two minutes to perform the operation. I have tried running a goal seek via VBA and setting Calculations to manual before running the operation but this doesn't seem to help. Does anyone have any ideas on how to speed the process up or any alternatives?

 

[Fazza]

Hi,

Difficult to advise based on lack of knowledge of the set up.

Try changing the extremely large workbook to a normal sized workbook.

Remove as many formulas as possible. If there are large amounts of data, consider moving it as much as practical to separate files.

HTH, Fazza

 

[Biz]

Does using Screenupdating and Display alerts switch off with application.calculation as manual help?

Application.ScreenUpdating = False
Application.Calculation = False
Application.DisplayAlerts = False

'Your Code

Application.ScreenUpdating = True
Application.Calculation = True
Application.DisplayAlerts = True

Biz