Hello,
I am testing the import data from 2, or more, spreadsheets from a SharePoint folder into one.
It is a really simple test. Sales for 2 different departments. The same setup in each Spreadsheet. Converted to a table in both
Quarter - Value
Q1 - Numbers
Q2 - Numbers
Q3 - Numbers
Q4 - Numbers
It works well to connect to the SharePoint Folder, I select Combine and load. The preview looks great. I can choose the table or the spreadsheet. They are identical, and both looks correct.
When I proceed, I end up with an error. It adds a 5 line:
I have tried to edit, and remove the last row, but no success.
I get the same error if I choose to use the table or spreadsheet as a source.
Any idea what I do wrong here, or suggestions for a solution?
It looks like it is an error already from step 1. It can not recognize the second spreadsheets table:
Best regards
- Geir
I did some search and why. The Tabs in the different worksheets must have the same name.
So the case is solved, and closed.
Best Regards
- Geir