Sign in
 
Home20132010Other VersionsLibraryForumsGallery
TechCenter >
> 
> 
Excel 2010 - refresh backgroundquery false - on Server 2008 R2

Answered Excel 2010 - refresh backgroundquery false - on Server 2008 R2

  • Thursday, April 05, 2012 3:56 PM
     
     
    Sign In to Vote
    0

    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"

    Suggestions?

    Fuel

     

All Replies

  • Tuesday, April 10, 2012 1:49 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi,

    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
    http://office.microsoft.com/client/helppreview.aspx?AssetId=HV805533949990&lcid=3081&NS=EXCEL%2EDEV&Version=12&pid=CH080553391

    Please try troubleshooting the network issue on the server.


    Sincerely
    Rex Zhang

    Rex Zhang

    TechNet Community Support

     
  • Tuesday, May 01, 2012 3:28 PM
     
     
    Sign In to Vote
    0
    Will 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.

    Fuel