I have a master spreadsheet that I want to convert to xlsm format. However,
I have two other spreadsheets that utilize MS Query to pull data from my
master spreadsheet. How can I convert my master spreadsheet without losing
the MS queries I have built in the other two spreadsheets? Is there a simple
conversion process? I have tried to update the individual ms queries but I
keep on getting error messages when I point to my master spreadsheet with the
xlsm extension. Thanks.