Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 142
  • Last Modified:

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?
0
Angela_Wilcox
Asked:
Angela_Wilcox
  • 2
  • 2
  • 2
1 Solution
 
BrianGEFF719Commented:
>>Where do I even start to try and find what is causing this?
Clearly if it works for everyone else and not him it must be a problem with his system configuration and not the code.

I would suggest running virus/spyware scans, unintsalling and reinstalling MS Office. If that doesnt fix it, do a fresh windows install.


Brian
0
 
seshu123Commented:
re install the ms office and check that it will solves the problem
0
 
Angela_WilcoxAuthor Commented:
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...
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
seshu123Commented:
accpet Mr. Seshu123
0
 
Angela_WilcoxAuthor Commented:
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.
0
 
BrianGEFF719Commented:
Hi Angela_Wilcox,
I would be happy to further help you try to debug this problem. Please post your latest findings/thoughts.

-Brian
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now