The instructions below were made with Microsoft Excel 2013 for Windows.
- Open an existing document or create a new one. Choose the Data Menu.
- Choose From Web.
- Type the address for your tracking bug. You should come up with a unique name for this document so when it is opened later you can tell which document it was. The address should be similar to http://DOMAIN/index.php?id=ID&type=img but you need to replace DOMAIN and ID with your own values. Choose Go to load the URL you entered.
- Click the tiny green arrow in the corner. This tells Excel what to read from the page. In this case, the page is blank so we choose the whole thing.
- Choose a cell to insert the data. It does not matter where as we will hide the whole sheet later.
- Choose Properties.
- Check the box next to: Refresh the data when opening the file. This tells Excel to load the tracking bug every time the file is opened.
- Choose OK twice.
You will see data in the cell you chose. To hide this:
- Choose the + symbol to add a new sheet.
- Right-click the sheet where your tracking bug is.
- Choose Hide.
You may want to rename the remaining sheet to something more specific.
Save the file and close Excel.
When the spreadsheet is opened, Excel will not automatically trigger the tracking bug. Instead, it will prompt the user with a security message as shown here:
Choosing Enable Content will trigger the tracking bug. Excel will remember this and not ask the next time the same user opens the same document.