I'm not sure if this should be an Excel post or a SharePoint post. If it needs moved, please say so.
HELP! I need help finding reference material/instructions on how to split a file into two files and keep them linked when they're stored on a SharePoint server.
I have an Excel file I created nine months ago that you guys have helped a lot on. It combines 40 different files into one and has 91 different dashboards linked to the data. The file was created with the "Keep everything in one file" request in mind so no queries or external links were used.
Now the file has been moved to the SharePoint server and has so many calculations in it that the connection for the data entry person is timing out when they're entering the data. I've been asked to split the existing file into two files with data into one file and the dashboards and "staging" in another file. The only references material I can find online on how to link files and keep the files linked explains how to create the data files and dashboards and how to link them when creating. I cannot find information on how to divide an existing file.
I have copied the file on my computer and divided it successfully (although you have to have both files open for the dashboards to update). As soon as I move both files to the SharePoint they can no longer find each other. Does anyone know how to do this? Do you know of any reference material or videos that can help? I'm reaching out in hopes that I don't have to re-create the file I've been working on for the last nine months.
HELP! I need help finding reference material/instructions on how to split a file into two files and keep them linked when they're stored on a SharePoint server.
I have an Excel file I created nine months ago that you guys have helped a lot on. It combines 40 different files into one and has 91 different dashboards linked to the data. The file was created with the "Keep everything in one file" request in mind so no queries or external links were used.
Now the file has been moved to the SharePoint server and has so many calculations in it that the connection for the data entry person is timing out when they're entering the data. I've been asked to split the existing file into two files with data into one file and the dashboards and "staging" in another file. The only references material I can find online on how to link files and keep the files linked explains how to create the data files and dashboards and how to link them when creating. I cannot find information on how to divide an existing file.
I have copied the file on my computer and divided it successfully (although you have to have both files open for the dashboards to update). As soon as I move both files to the SharePoint they can no longer find each other. Does anyone know how to do this? Do you know of any reference material or videos that can help? I'm reaching out in hopes that I don't have to re-create the file I've been working on for the last nine months.