Storing data sets too large for Excel in Access

[Robertvk]

Hello,

I have a huge binairy workbook which calculates the financial forecast. This file is too big for its own good (21mb). I was wondering how to solve this. I thought of two possibilities:

1. Create multiple workbooks which calculate a part of the operation. Then, when it’s done VBA can transfer the output to the core file. In this way I figured it would be less stressfull for the PC.
2. Create an Access database tool. I suppose Access is made for data sets. I have limited experience but this might be the right choice for my project.

Notes:
The source data doesn’t constantly change. These forecasts are made only three times per year.
I already remove formulas after calculation to decrease workload.

Thanks in advance for any suggestions!

 

[healey21]

Have you tired saving the workbook as a binary book as this should reduce the memory and quicken the workbook up .

 

[Robertvk]

Have you tired saving the workbook as a binary book as this should reduce the memory and quicken the workbook up .

Yes, it is already a binary workbook.

 

[alansidman]

Access is true Relational Database. Here is a link on how to set up a database so that all data is normalized. Look at it and then determine if your data can be fed into a database and achieve the desired results.

http://sbuweb.tcu.edu/bjones/20263/access/ac101_fundamentalsdb_design.pdf

 

[Robertvk]

Access is true Relational Database. Here is a link on how to set up a database so that all data is normalized. Look at it and then determine if your data can be fed into a database and achieve the desired results.

http://sbuweb.tcu.edu/bjones/20263/access/ac101_fundamentalsdb_design.pdf

Thank you, I'll take a look at it.

 

[mole999]

When you Ctrl + End on the data sheet, does the selection drop to the last populated cell

 

[Robertvk]

Yes, it does.