ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I delete data,formula,and formating PERMENENTLY? (https://www.excelbanter.com/excel-programming/373426-how-do-i-delete-data-formula-formating-permenently.html)

Robin Block

How do I delete data,formula,and formating PERMENENTLY?
 
I have two linked workbooks. One is 5224KB big and the other is 70477KB big.
I delete data and add data on a daily basis. the size of the workbook
increase and increases. these books are used for budgeting so I am not adding
more information, I am only changing the amounts. How can I permenantly
delete data to reduce the size of the woork books?
--
Robin Elizabeth Block
Financial Accountant

Tom Ogilvy

How do I delete data,formula,and formating PERMENENTLY?
 
Used Range Reset
http://www.contextures.com/xlfaqApp.html#Unused

might be what you need

--
Regards,
Tom Ogilvy


"Robin Block" wrote:

I have two linked workbooks. One is 5224KB big and the other is 70477KB big.
I delete data and add data on a daily basis. the size of the workbook
increase and increases. these books are used for budgeting so I am not adding
more information, I am only changing the amounts. How can I permenantly
delete data to reduce the size of the woork books?
--
Robin Elizabeth Block
Financial Accountant



All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com