<div>
Just to be clear this will retain the actual data in the file so we can distribute it to locations that won't have access to the data sources?
</div>


Just to be clear this will retain the actual data in the file so we can distribute it to locations that won't have access to the data sources?

<div>
Yes. But even without doing anything, the data is there as long as you don't refresh the queries.
</div>


Yes. But even without doing anything, the data is there as long as you don't refresh the queries.

<div>
Question is still open... Does it mean you are in requirement of some alternative solution.
</div>


Question is still open... Does it mean you are in requirement of some alternative solution.

<div>
<div class="content wysiwyg-content">
If we have a Excel spreadsheet that gets populated from external datasources is there a way to save a copy of that spreadsheet with all of the data queried as a spreadsheet without the dependancies on the external data sources.<br />
<br />
We would like the file to be viewable offline with all of the values populated.<br />
<br />
Thanks in advance.
</div>
</div>


If we have a Excel spreadsheet that gets populated from external datasources is there a way to save a copy of that spreadsheet with all of the data queried as a spreadsheet without the dependancies on the external data sources.

We would like the file to be viewable offline with all of the values populated.

Thanks in advance.

Excel External Datasource save results as full Excel file

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.