Hi there;
I have a huge data set in an excel spreadsheet that is used to create drive usage graphs and charts for a very large VM infrastructure. Currently I am using just one Excel spreadsheet to collect and display the data. The downside is that it is now 13 MB, so hosting on our SharePoint site and having our users access the graphs and charts that way, is pretty clunky. I was trying to separate out the chart and graph generation from the actual data collection.

The graphs and charts use the offset feature to populate the data.

If I have an excel spreadsheet that has charts and graphs in it and uses the offset feature to populate the data, can I draw from an access database instead?

How do I link an excel spreadsheet to tables/queries in a database?

thanks
MW

Hi,

I found this info. It may help you.
https://stackoverflow.com/questions/...2010-using-vba

If more help need come on back.