Importing and Analysing xls Files

Adding those dummy values is one of the 1st things that came to my mind. What I'm wondering is if there is a way this could be done automatically so that when I give this tool to my manager he doesn't have to fuf around adding dummy values.

Also, if the answer is just add them to the end or start with code; could it be done dynamically to avoid "polluting" the original every time it is loaded in?

Dan

Dan

Looking at the way you have your code, I'd open the data file, add the records, close and save the file, run your pivot table actions, then reopen the data file, delete the records then resave the file.

An alternative to this would be to open the data file, add the records, then save it to a fixed special location. Run your pivot from that copy of the file, and kill it when you have completed.

rylo