I have a fairly large excel file (183kb) that I am currently linking live to my workbook. The workbooks has multiple dashboards with charts, maps, filters, ect. Performance is fairly slow, with 1-3 minute loadtimes for filtering a dashboard.
I am wondering what is the best way to improve performance? I do not have access to a server or anything. Perhaps if I extracted all the data? or if I made all the excel sheets .csv would that help? If so can I do so with out having to entirely rebuild my entire workbook? I have already pasted values in excel, so running out of options as far as my knowledge goes