I know we can copy and paste special so that cells referencing other
workbooks are changed to values-only but wonder if there's a way to simply
save a multi-sheet, complex workbook that references many other workbooks as
values. This would be ideal for sending out up-to-date reports so that my
recipients aren't bothered with the "workbook contains values linked to
another workbook" pop-up. Any suggestions?