Jump to content
Strawberry Orange Banana Lime Leaf Slate Sky Blueberry Grape Watermelon Chocolate Marble
Strawberry Orange Banana Lime Leaf Slate Sky Blueberry Grape Watermelon Chocolate Marble

MSFN is made available via donations, subscriptions and advertising revenue. The use of ad-blocking software hurts the site. Please disable ad-blocking software or set an exception for MSFN. Alternatively, register and become a site sponsor/subscriber and ads will be disabled automatically. 



Sign in to follow this  
HyDeNCiTy

Excel error message, and don't know what to do

Recommended Posts

[Microsoft][ODBC Driver Manager] Driver does not support this function. is the error. This happens when I am trying to refresh the information in a pivot table. I h ave googled it and had no luck, so I though to turn to my buddies here at MSFN like I do with most of my problems. Hopefully I can find an answer since This is something I need to figure out because I am expected to answer for a project here at work.

Thanx in advance. :)

Share this post


Link to post
Share on other sites

HyDeNCiTy,

Your probably gonna hate me for this, but have you tried un-installing all of MS Office, and doing a complete re-install, its sounds stupid - but the chances are whatever got broken would probably fix itself with a re-install... or the other alternative - have you got the latest patches for your excel, they've had 100's since its original release...

If you really cant be bothered doing any of that

You might like to go to microsoft and obtain the latest version of MDAC(Microsoft Data Access Components) i think its service pack 8 last i checked... and install that...

Hope that is of some help :)

Share this post


Link to post
Share on other sites
HyDeNCiTy,

Your probably gonna hate me for this, but have you tried un-installing all of MS Office, and doing a complete re-install, its sounds stupid -  but the chances are whatever got broken would probably fix itself with a re-install... or the other alternative - have you got the latest patches for your excel, they've had 100's since its original release...

If you really cant be bothered doing any of that

You might like to go to microsoft and obtain the latest version of MDAC(Microsoft Data Access Components) i think its service pack 8 last i checked... and install that...

Hope that is of some help  :)

Larcos,

Thanx for the response..

I have already tried re-installing Office with no luck.

Also, the ODBC database is not SQL, it's an external data source that feeds the Pivot Table. I will check with the creator of the table to see if there's anything wrong with it, because I just found out that it wasn't just me having this problem. Thanx anyways.

But if anyone else has suggestions, please post them for I'm trying to get to the bottom of this, so suggestions r very welcomed. :rolleyes:

Share this post


Link to post
Share on other sites

I found out that the VFPODBC.DLL in System32 was allowing me to do this. I got a replacement and now I'm fine, thanx guys!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×