You can save subscription queries permanently by saving the Excel worksheet containing the formula associated with the query. The next time the Excel Worksheet is opened, the query appears in the Subscription wizard.