Forum Discussion
Pivot tables on Online file (Office 365/OneDrive)
Hi everyone,
premise: me & my workmates are using a Excel online file (everyone with a Microsoft online access)
our problems is that our file is oversized due to a lot of pivot tables, so it is ...
Hello,
Excel online cannot use data connections to external files. Everything must be in the same workbook.
But maybe you don't need to open Excel in the browser to work with the files? If the files are shared via OneDrive, then you can open them in Excel for desktop. The newest release of Excel in Office 365 supports co-authoring in Excel for desktop.