Share via

Excel File Problem with Office 2016

create share 646 Reputation points
2020-10-23T05:06:25.507+00:00

Hi,

I am getting the below error message after clicking on a button in excel file linked to a pivot table. The same works if i use office 365.

34492-excel-error.png

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,674 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 23,191 Reputation points Microsoft Vendor
    2020-10-23T10:40:12.227+00:00

    Hi @create share ,
    It seems that the Workbook contain connections in Excel. What kind of connection did use in Excel? Do you know where did you save the source data?
    Try to save Source Data in a separate excel file and recreate the connection.
    Go to Data- Connections- Properties. The connection string and command string will be shown. Try to edit it and paste the full path of the source data:
    34567-240.png
    Try this method and check if this will help you, any updates please let me know and I'm glad to help you.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. create share 646 Reputation points
    2020-10-31T03:42:16.74+00:00

    There are multiple sources. One of them is

    Provider=Microsoft.Mashup.OleDb.1;Data Source=$Workbook$;Location=Customers;Extended Properties=

    While checking the queries, i found all the queries were trying to find data source files in C drive, which does not exits in C drive.

    The question is that how is it working with office 365 without any problem?

    0 comments