Hi, I have an Excel workbook which contains about 12 worksheets and 12 Pivot Tables respectively. The database for those pivot tables is externally connected (with Power Query). Now, the file size is about 3MB, is there any way to reduce it? I read online that binary files can't be read by Power Query, but what if I saved the file containing the pivot tables as binary and keeping the database file as xlsx file? Can Power Query still work? Or maybe there is another way to reduce file size?
Many thanks,
Shay
Many thanks,
Shay