Hello.

I was trying to figure out the best way to 'schedule' a spreadsheet(s)
to update.

I have a bunch of spreadsheets that consist of a pivot table linked to
Access. I need to update these spreadsheets once a week and don't want
to go into each one separately. I was hoping I could schedule a task
to update the workbooks while I'm not at work. My initial thought was
to create a new worksheet that has some code that opens the
spreadsheet, updates the data, closes the spreadsheet and then moves on
to the next. The problem is that I get prompted to Enable Macros and
the scheduled task cannot continue without user interaction.

Does anyone have any suggestions that would allow me to update a
spreadsheet on a weekly basis without needing user involvement.

Any help or suggestions are appreciated.