I am hopeful someone can direct me to lotus script that will accomplish exporting a datbase view to an existing excel spreadsheet (not a new one, I already know how to do this). The specific spreadsheet has a pivot table which I do not want deleted, but I want to pivot table to use the new data that was exported.
Any help would be much appreciated.