Forum Discussion
Efficiency - Multiple Excel Files vs One file multiple sheets / tabs
Hi Using Excel files in Sharepoint, is it more efficient to import from multiple Excel files or from one file with multiple tabs? Or is there no practical difference? I'm talking about 12-15 tab...
HI Anonymous,
I think get data from one file should be better, you only need to get data from one source file, then you can duplicate the query table and change the navigate steps to redirect to different sheets.
It also helps you to reduce maintain time and you only need to handle one data source file.
Regards,
Xiaoxin Sheng
HI Anonymous,
I think get data from one file should be better, you only need to get data from one source file, then you can duplicate the query table and change the navigate steps to redirect to different sheets.
It also helps you to reduce maintain time and you only need to handle one data source file.
Regards,
Xiaoxin Sheng