Excel VBA works for 1 user, but not another

[shouyeah]

I have a Excel file using VBA that I am able to run all macros just fine. Another user was able to run the file just fine last month and the month before, but for some reason, she is unable to run the macro this month. When running the macros, she gets the Run Time error 1004, application or object defined error. She sent me the copy of the file she was using and I was able to run the macros with no issues. When she clicks "debug", it highlights

Selection.QueryTable.Refresh BackgroundQuery:=False

Any ideas as to why she is all of a sudden unable to run the macros when she was able to do it before?

 

[prabby25101981]

Could be an issue with the version difference. Did she upgrade or downgrade her version of excel in recent past?

 

[p45cal]

Is the same cell(s) selected when both of you run it?
What is the query-table querying? Is it available to her? Test by refreshing maually.

 

[Taul]

has she enabled Analysis toolpak VBA in the tools Add-Ins menu

 

[shouyeah]

Thanks for the ideas...however:

1. prabby25101981: There is a version difference. I created the file using Excel 2002 and she has Excel 2003. However, she had Excel 2003 last month when she ran the file and it worked fine, so I'm inclined to think the version is not the issue since it worked before.
2. p45cal: The same cell is selected. It is in the VBA to select cell A1 first before running the query.
   • I also had her right click on cell A1 and then click "Refresh Data", however nothing happened.
   • When I manually right click on A1 and click "Refresh Data", the data refreshes.
   • The query uses a "generic/shared" Data source and User Name, so nothing is tied to her or my individual user name.
3. Paul-H: The Analysis Toolpak and Analysis Toolpak VBA items were already "checked".

Any additional ideas would be greatly appreciated.

 

[p45cal]

p45cal: The same cell is selected. It is in the VBA to select cell A1 first before running the query.

• I also had her right click on cell A1 and then click "Refresh Data", however nothing happened.
• When I manually right click on A1 and click "Refresh Data", the data refreshes.

So you can manually refresh, she can't. Then it's not likely to be vba the problem, more the querytable can't refresh because perhaps the source data isn't available to it, or the querytable itself has been corrupted or lost altogether. Time for some detective work.