+ Reply to Thread
Results 1 to 2 of 2

Excel file linked to Access Database - When I share, users are unable to Filter / Sort

  1. #1
    Registered User
    Join Date
    01-16-2013
    Location
    Oakland, CA
    MS-Off Ver
    Excel 2010
    Posts
    22

    Question Excel file linked to Access Database - When I share, users are unable to Filter / Sort

    Hi,

    I have an Excel Document that is linked to an Access Database. Under Data Tab in Excel, I'm able to link to Access, and clicking Refresh updates my Excel Document.

    My problem is I'm sharing the Excel File. When I open the document, I'm able to Filter/Sort and manipulate the information any way I want. The problem is when I send the Excel file out to others, they are not able to Sort and Filter the data in the Excel file. They are telling me that options for Sort and Filter are grayed out in Excel. They have tried resaving the document, but it's not working for them.

    I've tried breaking the link to Access after refresh, doing a Save As, but this doesn't seem to correct the problem. I've tried going into Data Properties, and unchecking 'Preserve Column Sort/Filter/Layout', and this didn't help either.

    Is there anything I can do, other than copy/paste of the data rows and column into a new Excel Sheet? It really seems like there must be some setting I'm not seeing, which is preventing them from having this ability.

    Thanks!

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2304 (Build 16307.20006) Win 11 Home 64 Bit
    Posts
    22,567

    Re: Excel file linked to Access Database - When I share, users are unable to Filter / Sort

    This should be helpful in understanding what happens when you set a workbook to share.

    http://blog.contextures.com/archives...in-excel-2010/
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 02-08-2013, 07:31 PM
  2. Refresh Excel Sheet Linked to Access Database
    By sainttomn in forum Excel General
    Replies: 0
    Last Post: 11-11-2011, 11:58 AM
  3. Excel file linked to access database
    By simon pitt in forum Excel General
    Replies: 5
    Last Post: 07-15-2009, 09:36 AM
  4. [SOLVED] What is the maximum number of users that can share Excel File?
    By pfine in forum Excel General
    Replies: 1
    Last Post: 03-10-2005, 05:06 AM
  5. Excel / Access Linked Database Problems
    By edwa5823 in forum Excel General
    Replies: 0
    Last Post: 03-04-2005, 10:51 AM

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