The export process cannot link directly to Excel templates.
Several users have been able to overcome this limitation as follows:
- Create a multi-sheet xls workbook, with the first work-sheet set up with your desired content and formatting.
- Export a profile page from PCensus to Excel
- Select the entire worksheet from your export file, and copy and paste it to the second worksheet of your formatted workbook.
- Populate the data fields in your formatted sheet using references to the pasted data in the second worksheet.
Because the profile worksheet exported from PCensus always has the same layout, you can refresh the data in your worksheet by pasting new exported files into the second sheet.
The attached worksheet gives a simple example of the process descibed above.
