none
Embedded query not saved after change RRS feed

  • Question

  • Microsoft Office Professional Plus 2010 

    Excel macro spreadsheet  ie .xlsm 

    Embedded query is in a sheet. 

    MsgBox (QuerySheet.QueryTables(1).Connection) returns the following ( albeit i've hidden some info) 

    URL;http://database.company.com/r=si01,si02,si03

    I right click in cell, edit query, query window comes up. I change si01 to be si33.  Query occurs, I select data block I want, data is refreshed on tab. Everything is good :-) 

    Recheck querytable..  

    MsgBox (QuerySheet.QueryTables(1).Connection) returns the following now

    URL;http://database.company.com/r=si33,si02,si03

    Save the file, doesn't matter if save or save as. 

    Reopening this file, my embedded query has REVERTED to the original, showing si01 rather than si33. 

    Any suggestions on how to resolve? Thanks!

    Monday, January 19, 2015 7:15 PM

All replies

  • Hi Kneelh,

    Base on my test in office professional 2013, it works fine. I will check it in office 2010.

    Could you reproduce that issue in another machine?

    Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, January 20, 2015 9:09 AM
    Moderator
  • Hi Kneelh,

    Base on my test in office Professional Plus 2010, it works fine, I can’t reproduce that issue.

    Please share the sample file that could reproduce that issue on the OneDrive, we will check it.

    Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Tuesday, January 20, 2015 9:30 AM
    Moderator