Results 1 to 2 of 2

Excel slow on calculations

Threaded View

  1. #1
    Registered User
    Join Date
    05-23-2011
    Location
    Lincoln, NE
    MS-Off Ver
    Excel 2007
    Posts
    30

    Excel slow on calculations

    My current problem with my workbook is that it is taking a long time to save. I believe that the issue may very well be related to how I have this set up but I didn't know another way.

    Here is what I have: I created an excel spreadsheet that employees will use to log fingerprints that they take. I wanted to also be able to track the time that it takes to complete the fingerprinting process as well as simplify the data entry process and control some of the data that is logged. I created a userform that starts a timer when the user selects their name from the drop-down as the individual doing the fingerprinting. The timer stops when the user completes the fingerprinting and presses the "Log" button on the userform. The "Log" button validates the entries, writes the data to the spreadsheet and then saves the spreadsheet to avoid accidental loss of data. I think created a separate tab within the workbook for each month. On these monthly tabs, I am wanting to tally or count the number of prints that were taken each day and for each reason that prints are taken (reasons may include conceal/carry weapon permits, adoptions, bar exam, etc....). I used Countifs functions to count how many records we have for each fingerprint reason for each day.

    When I save the workbook (regardless of if I save it using the Save & Clear button on the userform or if I click the save button within the workbook itself, the status bar at the bottom of the screen shows the following "Calculating: (4 Processor(s)): 15%" and the percentage amount increases gradually. It takes close to a minute to complete the save. I'm assuming that this is because it is going through each and every cell with a Countifs function and recalculating it.

    Is there a better way to accomplish this? It doesn't really seem like my workbook is excessively large or contains an excessive amount of formulas/functions that would require a ton of time to calculate but what do I know. My workbook is attached.

    Note: This issue may be better suited to a different forum as I don't think the issue is really related to the VBA code. Been working on this for three days now!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1