1 Reply Latest reply on Mar 29, 2012 2:12 PM by Russell Christopher

    Ways to improve speed with Excel

    J G

      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

       

      I appreciate your help.