Excel External Datasource save results as full Excel file

Posted on 2012-09-14
Last Modified: 2013-09-03
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.
Question by:NORLEM
    LVL 39

    Accepted Solution

    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.


    Author Comment

    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?
    LVL 39

    Expert Comment

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

    Expert Comment

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

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Suggested Solutions

    Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now