Share via

MS Excel Power Pivot connection issue with MS Access Odbc

Ai Tee Ling (SG) 5 Reputation points
2026-02-02T14:28:51.0833333+00:00

Hi There,

I'm encountering problem Excel pivot refresh data failed when I was trying to pull data fm MS access.
below if the errors appearing. can you pls help. desperately need help to problem fix.

"[Microsoft][odbc Microsoft access drive] Operation is not supported for this type of object"

Best Rgds, Ling

Microsoft 365 and Office | Access | Development
0 comments No comments

1 answer

Sort by: Most helpful
  1. Karl Donaubauer 3,191 Reputation points
    2026-02-02T16:26:16.34+00:00

    Hi,

    Microsoft has made a security change concerning references to external databases. Check out our documenting blog articlethat includes the necessary measures and workarounds.

    Servus
    Karl


    Access Forever News DevCon
    Access-Entwickler-Konferenz AEK

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.