Certain fractions being calculated in excel 2013

To fix this issue Re-reading your question, it occurred to me you got your terms mixed up and that may have been the underlying confusion that none of us properly answered.

This might help you The reason why you are having problems with your sheet is how you are opening your workbook. Try changing your Excel app and workbook allocations to this:

Set ExcelApp = CreateObject("Excel.Application")
Set ExcelBook = ExcelApp.Workbooks.Open(str)
Set ExcelSheet = ExcelBook.Worksheets(1)

I think the issue was by ths following , Have you tried using DoEvents in the pre-processing macro?
If you have a loop where you're processing the CSV file line by line then use DoEvents every so often to give any pending events a chance to run. It would be overkill to call it on every line so maybe start with every 100 lines and adjust from there.

may help you . Browse to Central Administration in Sharepoint Select Manage Service Applications Select Secure Store Service (Type: Secure Store Service Application) Under Manage Target Applications, Click on New Enter Target Application ID = "TFS", Display Name = "TFS", Contact Email="Whatever", Target Application Type = "Group", Target Application Page URL = "None" and click Next Do not enter anything on this page as it's asking for fields name and not the actual credentials. Enter Target Application Administrators and Members and click ok. it will take you back to the page that was displayed after performed step 3. Now right click on "TFS" and select "Set Credentials" and then enter the username and password that this account will be running under. Now login to the TFS Server and click extensions for Sharepoint products. Select the sharepoint web application you are using. Click Modify access. Enter "TFS" under the Enterprise Application Definition field. Also just to make sure "Excel Service applications are configured properly, Click on "Excel Service Application "Type: Excel Services Application Web Service Application". Click on Trusted File Location and make sure the site collection is added to the Trusted File Location and location type is "Microsoft Sharepoint foundation". under Trust children check "children trusted". under Allow external data select "Trusted data connection libraries and embedded". Go back to page displayed after step 14 and select "Global Settings". File access method = "impersonation", Under Analysis Services EffectiveUserName, check "Use the EffectiveUserName property". Check "Use an existing Unattended Service account" radio button and under Target Application ID: enter "TFS". Also make sure under Trusted Data Providers, the providerid your excel application is using is listed.

wish helps you Figured it out:
Need to use the SUBTOTAL function then the corresponding function # (i.e. 2 is count, 9 is sum etc.)