Purging unwritten query data

Purge data to delete unwritten query data without deleting the entire query.

This function can purge current sheet data only or all data in a query.

  1. In Infor Spreadsheet Designer, create a query.
    For detailed information, see Creating a query in Infor Spreadsheet Designer for Microsoft.
  2. Enable background queries and query write notification.
    For detailed information, see Enabling a prompt before Excel is locked to write data
  3. Refresh the query.
  4. When the write data prompt appears, select Write Later.
    The Purge Data drop-down menu is now displayed on the Infor Spreadsheet Designer ribbon.
  5. When you open the Purge Data drop-down menu, you can choose to purge current unwritten sheet data or all unwritten data.
    Purge Data/Purge Sheet Data
    Current unwritten sheet data will be deleted from All unwritten sheet data from the current workbook will be deleted from %APPDATA/Infor/BG. In Infor Spreadsheet Designer, the Write button will revert to Refresh.
    Purge All Data
    %APPDATA/Infor/BG. In Infor Spreadsheet Designer, the Write button will revert to Refresh.