Spread sheet is getting too large

grev

New Member
Joined
Sep 4, 2002
Messages
21
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.
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Try this:

1. Right click the tab of the sheet you wish to EMail and choose Move or Copy.
2. In the To Book box choose (new book) and check Create a copy (very important).
3. In the new workbook right click the grey box above the row numbers and to the left of the column letters and choose Copy.
4. Right click again and choose Paste Special, check Values and click OK.
5. Save the new workbook with a name you like and EMail that.
 

Forum statistics

Threads
1,148,145
Messages
5,745,049
Members
423,917
Latest member
Frank1931

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top