Hi Frederik,

Yes, Excel does create temporary files when you open a workbook. These files are used to store information while you're working on the workbook and are deleted when you close the workbook. By default, these temporary files are created in the same directory as the workbook you're working on.

However, if you want to change the location where these temporary files are stored, you can do so by following these steps:

1. Open Excel and click on the File tab.
2. Click on Options.
3. In the Excel Options dialog box, click on the Save tab.
4. Under the Save workbooks section, you'll see a field labeled "Default file location". This is where you can specify the folder where you want Excel to store your temporary files.
5. Click on the Browse button to select a new folder location.
6. Once you've selected the folder where you want your temporary files to be stored, click on OK to save your changes.

That's it! From now on, Excel will create temporary files in the folder you specified instead of the same directory as your workbook. This can be useful if you want to keep your temporary files separate from your working files or if you want to store them on a different drive for performance reasons.