Hi all,

I set up a worksheet that had links to two separate spreadsheets. The original was a test for "January" and now that i got it fully functional i want to create copies of it for the rest of the months. Normally i would use the "Replace" option to just change out the "Jan" in the spreadsheet name to "Feb" so that it would pull from each correct month. Unfortunately Excel is not allowing me to do that and is attempting to change the data in the source workbook. Does anyone know of a way to make this work without me having to manually enter the other 11 months because the first one took about 2 hours.

Thanks in advance!