Create XLS with Pivot on the fly

MeteredOut

DullGreyGuy said:

MeteredOut said:

If the export from the DB is to a known location and file name, have you tried creating a new sheet and referencing the exported sheet as an external sheet?

It could work but not sure having to open two files each time isn't much less clunky than having someone go into the file and manually add either a checking grid or conditional formatting etc but worth considering 

In theory, if set up correctly, it should just be a matter of opening the second file (that references the exported file) and refreshing it to update the references. From memory, the references will need the full path to the referenced sheet though, otherwise the file being referenced needs to be open too (that's why I said the export needs to be to a known location/file name).