I have a worksheet that is quite complex (have lookups from other worksheets along with queries)I need to email this worksheet to others daily. It is getting quite large thus timely when sending or opening. I was wondering is there a way to simplify the spreadsheet prior to emailing. Such as eliminating all of the lookup links, queries etc... Something like a cut and paste, pasting only the values, but also keeping the format(borders, cell size etc..) of the sheet itself. It seems like a MACRO but maybe there was an easier way especially when you are trying to copy the format. Any help would be appreciated.