Excel without Formula

Saving a report without formulas


First open the report and click into the DV addin, select “Save Without Formulas”


Make sure you save it with a new name so you do not save over the live report. Once saved you can right click on the file and copy then paste the report down to on your local PC.



    • Related Articles

    • DV Training Webinars

        http://www.datavisiontech.com/webinar.htm We find it useful if you open a session of Excel on one screen and the webinar on a secondary screen.  This allows the user to follow along with the exercises on the screen with your data in the Excel ...

    • DVAlert Error - Number of records don't match between tmp and inc...

      So, DVAlert is failing, the message is something like this: "IdBatch: 658 The numbers of records between tmpfactPMSBOB and incfactPMSBOB not match for cube PMS BOB" The problem is most likely that one of more of the dimensions has duplicate All ...

    • SSRS - Logon failed for the unattended execution account.

      This error will occur when setup execution account's password expired or changed. User will not be able to run any SSRS report and received the following error –                  The report server has encountered a configuration error.  Logon failed ...

    • DV Addin - Calling Alt-F9/DVUpload from a macro

      Dear Developer Divas, I have a macro.  It is a fine and cunning macro.  I want to Alt-F9 my Datavision formulas from my macro.  I want to DVUpload from my macro.  How can I do this? Signed Just Jamming with Jamacros Dear Jamanda, Excellent question! ...

    • MOHG/MOBI Cloud Patch Process

      MOBI Cloud Patch process     11 AM – 11:15 AM – Stop DVAlert services (There are three, DVAlert, DVAlert Market, DVAlert MOMLN) Login Open each manager, click the stop button, wait for clear Open services, stop each dvalert and set to Manual restart ...