Thursday, April 05, 2012 3:56 PM
Running Excel 2010. I have an Excel file with a simple recorded macro to pull data from another Excel file on a network share. When running the macro from a Windows 7 system, the process works correctly, but when I run it from a Server 2008 R2 system, I get a Runtime Error 1004. The debug highlights "Refresh BackgroundQuery:=False"
Tuesday, April 10, 2012 1:49 AMModerator
Base on the searching, it would appear that there is something wrong with the UNC path and when it goes to refresh it is unable to do it. That could be a network issue.
Query Table Refresh Method Help Link
Please try troubleshooting the network issue on the server.
TechNet Community Support
- Marked As Answer by Rex ZhangModerator Wednesday, April 18, 2012 2:38 AM
Tuesday, May 01, 2012 3:28 PMWill check that out. The user running the process is a remote user. When he runs it from the locally install apps it accesses data from a remote network and completes without error. When he runs the process from the RDS environment, the RDS servers are plugged into the same switch as the file server where the data is stored.