G'day all, as the title suggests, I believe the formulas I have on my excel sheet are causing excel to run exceptionally
I'm not new to excel, but complexed formulas is certainly not my forte and I have no idea on how to speed it
up, considering im just in the styling stage of setting up the next financial years profit and loss sheet.
i've got if anybody is able to assist is this:
I downloaded a 'profit & loss statement' file and have modified it to meet my business needs, and what i've done is added 2
additional worksheets, one being setup (which includes dates mainly) and the 2nd being a 'ledger' where I enter all the years
information in (like purchases, sales etc).
What the program/file is to allow is for the user (me) to enter details of sales, purchases etc into the 'ledger' form, and
then when I want to view sales, expenditure etc etc, I go to the profit & loss form, which is categorised by each month.
Now the formula i'm using is the '=sumproduct' formula. Currently, I believe this is what is causing the file to run
exceptionally slow, and all I have in there so far is just sample data for several months to ensure the formulas were working
Now the other thing that also appeared is when I added more formulas (have since deleted them), an
error message kept appearing saying out of memory or something.
Also whether this means anything or not, but im
using a 1month old computer that is an I7, so its certainly not a slow or old computer.
Any help is greatly
appreciated, as I find for a small business like mine, its just too expensive to get MYOB or other accounting software.
attached is the file. (the zip file is the .xls, and the other is the office 2007 version), same file, just saved
differently for those that might not have office 2007.