+ Reply to Thread
Results 1 to 2 of 2

How to save a workbook minus the Microsoft Query links

Hybrid View

  1. #1
    Registered User
    Join Date
    03-23-2004
    Posts
    23

    How to save a workbook minus the Microsoft Query links

    I designed a workbook that gets external data from an Access database using Microsoft Query. It works great. My issue is I need to save the workbook and email it to an end user who should not have any interest in the Access database. Accordingly, when the user opens the workbook there should be no linkages to the embedded Microsoft Query and no prompts should pop-up (ex: "enable" or "disable" query refresh.) How can I save the workbook such that all evidence of Microsoft Query is hidden / invisible to the end user?

  2. #2
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    667

    Re: How to save a workbook minus the Microsoft Query links

    click top left corner to highlight the whole sheet. then copy [ctrl c] right click in cell a1, choose paste special, paste values. This will replace all formulas and links with their resulting values.

    MM

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1