I've created a very large workbook (7 MB) which incorporates numerous formulas that reference various worksheets in the same workbook. The workbook contains over 100 individual worksheets. On a daily basis, data is added to several of the "input" worksheets, and the formulas in the "output" sheets automatically create the finished product. When I'm done formatting (headers, footers, dates, bold, color, etc.) the "output" sheets I hide all of the "input" sheets and save the file and it's ready to send to the client.
However, it's very difficult and "unprofessional" to send such large (7 MB) Excel sheets to clients via email. I've discovered the ability to convert these large files to .pdf documents and that greatly reduces the file size. This conversion process takes a lot of time though due to the large size of the workbook.
My question: Is there any way I can dramatically reduce the size of my workbook without compromising any of the formulas I've created or deleting any of the worksheets? I need to find a way to make these worksbooks more manageable and easier to send via email.
However, it's very difficult and "unprofessional" to send such large (7 MB) Excel sheets to clients via email. I've discovered the ability to convert these large files to .pdf documents and that greatly reduces the file size. This conversion process takes a lot of time though due to the large size of the workbook.
My question: Is there any way I can dramatically reduce the size of my workbook without compromising any of the formulas I've created or deleting any of the worksheets? I need to find a way to make these worksbooks more manageable and easier to send via email.