The model in excel is for the table, summary, and export design/properties. If you have a new data with the same format then your current model should work with the new spreadsheet. Saving a model in excel is basically saving the table, summary, and export properties.
Have you tried using your current model for the new spreadsheet?
Ok, I thought I had figured this out but I am stuck again.
What are the steps in using my excel model?
Do I need to save the original spreadsheet as a data base? I saved the original - do I even have to do that?
After I have made the model in data prep and organized the columns in classic I saved as a model?
So I have a new spreadsheet that I want to use the model on - how do I do that? Can you list out all of the steps?
Once you have the Monarch Classic model which is in .dmod format, you should be able to use it on your new spreadsheet. See below for the steps.
1. Open Monarch on Classic Mode
2. Click File>Open>Database
3. Browse for your Data Source which will be your new spreadsheet
4. Select Table
5. Browse for your model and then click OK and Accept