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!