Skip to main content
SharePoint

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

5
  • It seems like you are correct :) I do have calculated fields in the furthest right side of the table and it seems like they caused the problem. If I remove those calculated fields, and insert them after I update, can I then make a table that is wider than the sharepoint data (but with no calculated fields) just so I don't have to edit the table size everytime I update with new SharePoint fields? Thanks in advance. I really appreciate your help and I apologize for the slow reply. Commented Sep 22, 2015 at 14:36
  • I've tested some more. It seems like its the tables that messes it up. My client has seperate lists for keeping data in different areas. So the connections from SharePoint are set up to several tables. Lets say they have 4 Business units that enters data seperately. Then the information is stored in 4 different SharePoint lists and then connected to 4 different tables in Excel. Theres a consolidated pivot table set up from the data from the 4 different tables. When I set it up once with the current number of columns from the SharePoint data it works fine when I update. Commented Sep 22, 2015 at 15:33
  • But when I add new columns to the SharePoint data (in all the lists) - the warning I posted before comes up. Even when I have removed all the calculated fields from all the tables and the tables have the same number of columns. FYI: all the tables are placed in the same sheet below each other. You can see here the structure behind how its set up: imgur.com/CYg5Hom Commented Sep 22, 2015 at 15:41
  • The problem is that the tables are underneath each other. If one table grows, it will need to move or overwrite the table below it. That is not allowed. If you consolidate the tables into a pivot table, create them side by side instead of underneath each other. Or let each table use a different sheet. Commented Sep 22, 2015 at 20:52
  • You were right. Thank you very much for your replies. I've fixed the problem now, with your help :) Commented Sep 28, 2015 at 12:31