How do I Update a "List" spreadsheet.
Posted by Troy Buzzard on November 06, 2001 7:36 AM
I created a spreadsheet template, using the template wizard with data tracking, to save data to a List. When the "Save" button on the Standard toolbar is pressed it updates the List spreadsheet but also attempts to save the template spreadsheet. I want to keep the template spreadsheet READ-ONLY. I only want the List spreadsheet to be updated with new information I've entered. How can I do this using just the template spreadsheet? Is there a macro function I can use to update just the List spreadsheet?