Share via

Cannot open pivottable source file when excel file opened from a website

Anonymous
2010-09-20T19:58:20+00:00

Is there a workaround for this error msg "Cannot open pivottable source file" ? Occurs when opening an excel file that contains a pivot table from a browser.

None of the existing references to this issue solves the problem.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-11-19T17:24:01+00:00

    We have similar problem when using Internet Explorer 8.0

    1)Download file from Internet

    2)Click Open

    3)Excel File Opens

    4)Ask to Enable editing file because is from internet

    5)Ask to Enable Data Connection

    6)Error message cannot access PivotTable data source.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-06-14T19:38:15+00:00

    In my case the source data exists on the same sheet.

    This won't happen with the win xp- office 2003 combination (I have win 7- office 2003)

    Was this answer helpful?

    0 comments
  3. Anonymous
    2010-09-21T08:01:40+00:00

    Where is the source data for the pivot table?

    Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk

    Was this answer helpful?

    0 comments