Help me reduce the size of my Excel file based on Sharepoint query.

April 15, 2013 5:26 PM

I need some help with a situation where I have a bit of limited resources. Can you help me minimize the Excel file size while still keeping all data available for reporting use?

Here are my resources:
Sharepoint Server 2007 (I am a user, not IT Admin, so I can only work with the base installation.)
Excel 2003

I do not have access to Sharepoint designer, but have already built my list to work from.

I have setup an Excel spreadsheet based around a query linked to a Sharepoint list. Using that, I have built pivot tables to analyze the data, but it is rapidly growing in size. I need to limit the amount of data in the file, but allow all the data to be pulled to the spreadsheet.

I have tried setting the Data settings to discard external data when saved, but it is losing the list since there is no data in the list when it is saved.

I have tried to delete rows off the list and build a macro to refresh it, but Excel tells users that there are un-synchronized changes. Knowing my team, all it will take is someone to click the wrong button and synch the spreadsheet without discarding the changes, wiping out hundreds of lines of data.

posted by slavlin to Computers & Internet