Hi @krysten c, 

Welcome to the Community! Happy to help!

Do you minds sharing what syntax error is popping up? This will help us further identify what might be the problem here as there could be many template error messages potentially shown.  

Thanks for participating in the Community!

-Taylor 

Steps to fix-

Open the workbook that contains the broken link.

On the Data tab, click Edit Links.

The Edit Links command is unavailable if your workbook doesn't contain links.

In the Source file box, select the broken link that you want to fix.

Note: To fix multiple links, hold down COMMAND, and then click each link.

Click Change Source.

Browse to the location of the file containing the linked data.

Select the new source file, and then click Change Source.

Click Close.

Regards,

Rachel Gomez