will be helpful for those in need You simply need to change the cell format; you want to use ???/???. This will make Excel represent any decimal number to the closest fraction approximation it can find using the specified numerator and denominator significant digits (number of ? in the format string) If the cell input is directly a fraction, it will reduce it if possible but always keeping the fraction format.
= .10 will be converted to 1/10
= 0.1231 will be converted to 81/658 (supossing ???/??? format is used).
= 10/100 will be converted to 1/10
= 11/12 will remain as 11/12 as no reduction is possible.
= 1/1 will remain as 1/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.
Sharepoint 2013 connecting to TFS 2013 - Error with Excel reports
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.
Excel 2013: Table Slicers selection not changing values for calculated field (without VBA)