[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 145
  • Last Modified:

Excel External Datasource save results as full Excel file

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.
0
NORLEM
Asked:
NORLEM
  • 2
1 Solution
 
nutschCommented:
Try Data \ Edit Links \ Break links.
You can also set your queries to not refresh on open, so that you can keep the data connection active, but not try and refresh them.

Thomas
0
 
NORLEMAuthor Commented:
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?
0
 
nutschCommented:
Yes. But even without doing anything, the data is there as long as you don't refresh the queries.
0
 
AmboseJCommented:
Question is still open... Does it mean you are in requirement of some alternative solution.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now