Forum Discussion
Solved
OneDrive to SharePoint file transfer of a MS Forms' linked Excel file
I created a form to collect customer information online and linked it to an excel spreadsheet. It was done on my Business OneDrive but I wanted to move it to our company SharePoint and give access to other people in the company. I was able to move it but now it is not connected to the form anymore.
Is there a solution to move the links excel workbook to SharePoint and keep the link alive to the connected form?
I tried to create the form on SharePoint but did not work.
As you would know by now that I am not very knowledgeable on SharePoint so any help will be greatly appreciated.
Thank you.
Amand1040 I'm not at all familiar with how Excel file sizes can be calculated, but when you say 366K rows by 283 column, that means your file has over 100 million cells. If these all would contain 1 byte of data, that would already result in a file size of around 100MB. Then, your 140MB isn't all that strange.
Tested this by creation a file with 1 million cells with numbers. Saved it and the file size was 2.9MB. Perhaps my reasoning makes no sense at all, but if performance is an issue, consider connecting to the file with Power Query, rather than opening it in Excel.
1 Reply
- DingkunXie
Microsoft
You can create "Forms for Excel" in your SharePoint folders by clicking "+ New" and selecting "Forms for Excel." This will generate a new Excel file in the folder and create a Form that is linked to that Excel file.
