I've downloaded the 'Synchronising with sharepoint lists' add-in and have linked my spreadsheet to a sharepoint list, where any changes made to the spreadsheet then updates the sharepoint list. This spreadsheet is full of formulas but as soon as I click 'synchronise with sharepoint' all of the formulas in my spreadsheet vanish. Here I am referring only to my excel spreadsheet and not my sharepoint list, because I know the formulas don't extract to a sharepoint list anyway. Instead I would like to work from the excel spreadsheet with all the working formulas and then synchronise the sheet to a list in sharepoint for read only purposes only.
So is there a way that I can synchronise my spreadsheet to sharepoint and keep my formulas in my excel spreadsheet?
No comments:
Post a Comment