ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Archiving (https://www.excelbanter.com/excel-discussion-misc-queries/177713-archiving.html)

albertmb

Archiving
 
Hi everyone,

Once again I need your help.

I built a small sort of accountability system for a friend with excel. It
holds 108 files in 4 folders and takes up 823 MB.

The folders are as follows: Invoices (261 MB), Purchasing (524 MB) ,
Expenses (37.8 MB) and Reports (90 MB) The sizes of these folders will grow
when he will start using the system.

I am noticing that as is it takes quite a bit of time to have files open I
assume that the more it is used the slower it gets. All sections are split
into months, would it be possible to somehow archive used invoices outside
the functioning folder so it can run faster? I hope I managed to explain
myself properly.

Thank you for your interest


All times are GMT +1. The time now is 02:29 AM.

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