I have an Excel workbook I use to aggregate data from other excel workbooks.
My macros copy data from the secondary workbook and appends the data to the
primary workbook. My question:
Is there the capability to open up secondary workbook without the secondary
workbook executing any of it's macros and not do any calculations?
Is there a better way to pull data from another excel workbook? Links are
not an option.

Thanks,
- Pat