Hello everyone,
First post. I've met a match with Excel that I can't wrap my head around and I'd appreciate any advice you could give me.
I have some SharePoint lists that are linked to an Excel workbook with three sheets. All the editing is done on SharePoint and every week I need to create a snapshot of the data by refreshing the Excel file and saving-as a new file that includes the date. Is there a way to automate this? I've seen similar threads but not necessarily anything that's so specific as what I'm doing.
Thank you!
First post. I've met a match with Excel that I can't wrap my head around and I'd appreciate any advice you could give me.
I have some SharePoint lists that are linked to an Excel workbook with three sheets. All the editing is done on SharePoint and every week I need to create a snapshot of the data by refreshing the Excel file and saving-as a new file that includes the date. Is there a way to automate this? I've seen similar threads but not necessarily anything that's so specific as what I'm doing.
Thank you!