Link to home
Start Free TrialLog in
Avatar of Angela_Wilcox
Angela_WilcoxFlag for United States of America

asked on

Error on app that no one else is getting

We have an Excel/VBA application that has a great deal of code in it - and talks to a multi-dimensional database.  All good.  The app works for everyone except one person.  When he runs it, several pages fail with the message "Application could not retrieve the data. Please check the named ranges."  Given that I can turn right around and sign on to same spreadsheet - and it works fine for me - and we use same administrative sign on... what are we looking for in his Excel setup which could be causing this issue - as it has to be something unique to just him.  We have tested this on a dozen other machines - same sign on - same data request - everyone else can execute fine except for him.  Where do I even start to try and find what is causing this?
ASKER CERTIFIED SOLUTION
Avatar of BrianGEFF719
BrianGEFF719
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of seshu123
seshu123

re install the ms office and check that it will solves the problem
Avatar of Angela_Wilcox

ASKER

OK - I was hoping maybe it was a setting in Excel that he had inadvertently turned on that no one else had... We will do as suggested and I will get back to this...
accpet Mr. Seshu123
It is not possible for us to uninstall and reinstall his entire MS office installation due to other constraints.  Agreed that it is obviously him and his config - but sure would like to know why.  This is a brand new desktop that was just staged less than 6 months ago.  And we have a pretty standard installation process company wide.  Anyway - I will accept the answers above - and note that they are untested.
Hi Angela_Wilcox,
I would be happy to further help you try to debug this problem. Please post your latest findings/thoughts.

-Brian