Select file dialog appears when executing editing formula

[deferredtax]

Hi,

Acutally I have this problem when using VBA code but it can be reproduced easily without using VBA. The problem is that an Select file dialog appears when editing a formula which uses another Excel file that does not exist yet. However, the file will exist in future and consequently I want the dialog not to appear. (I use a vba script that changes the formula and this script is executed quite often - everytime a formula is changed, the dialog appears.

1. Create an empty excel sheet
2. Insert any formula into any sheet cell: =COUNTA('c:\[Report.xlsx]Input'!$H$12:$H$90)-1
3. Click Enter
4. The dialog will appear

Does anybody know how to prevent the appearence of the select file dialog?

Thanks a lot!!!

Best regards!

[deferredtax]

Hi,
I've already found a solution for this.
You have to disable and enable the Excel alerts (before and after your vba code):
Application.DisplayAlerts = true
code...
Application.DisplayAlerts = false