Copying Excel spreadsheet

A problem when using Forms + Excel together, especially since Forms doesn't provide native templating features or easy detachment from an existing spreadsheet.

Action you can take…

Create and save a blank response Excel sheet from the master Form

Create a formula/dashboard workbook that reads data via Power Query

For each event: duplicate the Form, get new Excel response file

Point the formula workbook to new file via Power Query

Save each event under a folder like Events/EventA/, Events/EventB/, etc.

Avoid…

Copying worksheets with links to external files → causes broken references or hardcoded filenames.

Find/Replace on external links manually → error-prone and not scalable.

Using Forms connected directly to your formula workbook → risky, as structure changes can break formulas.

Hope this information helps you a little.