I'm working on a project for a client. This client uses a form in SharePoint to enter and save data from certain projects into SharePoint lists. This data is setup to connect to an Excel file, that is working as a report on the data (pivottables, graphs etc).
The connection between the spreadsheet and SharePoint is established. The problem arises when my client enter new columns in SharePoint (to hold new data) to existing (and future) projects. When the Excel file is opened and tables are refreshed to fill in the new data, an error pops up. The error message is in danish, but translated it sounds like this:
The action is not allowed. The action tries to move cells in a table in the spreadsheet.
I reckon this has something to do with the current table doesn't fit the data-structure from SharePoint?
What can I do about this? Does the connection with Excel has to be rebuilt? Or can an automatic solution be set up, so that the Excel table always fits the SharePoint data, even when additional columns with data are added in SharePoint?
I have no experience or expertise with SharePoint, but I'm fairly good at Excel. Unfortunately I'm not able to upload any file or reveal any SharePoint data, since this is very confidential.
Any help on this subject will be greatly appreciated