Hi there,
I am currently using Power Pivot with 18 data tables and the file is approx. 20MB. We would like to add additional data and functionality to the file however I am finding excel 2013 is quite unstable and is prone to freezing.
We are investigating using SQL database and importing data into excel initially and maybe in the future once cost freeze is removed we may look at BI. Has anyone gone though a similar exercise? Would be interested in any tips. Is there a good forum for beginners? it is all quite daunting, I think I need to read SQL for dummies!
I am currently using Power Pivot with 18 data tables and the file is approx. 20MB. We would like to add additional data and functionality to the file however I am finding excel 2013 is quite unstable and is prone to freezing.
We are investigating using SQL database and importing data into excel initially and maybe in the future once cost freeze is removed we may look at BI. Has anyone gone though a similar exercise? Would be interested in any tips. Is there a good forum for beginners? it is all quite daunting, I think I need to read SQL for dummies!
