News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • Excel 2016 vs. Dragon Professional 15

    Posted on Kathy Stevens Comment on the AskWoody Lounge

    Home Forums AskWoody support Microsoft Office by version Questions: Microsoft Office Excel 2016 vs. Dragon Professional 15

    Tagged: 

    Viewing 6 reply threads
    • Author
      Posts
      • #2062045 Reply
        Kathy Stevens
        AskWoody Plus

        Until recently I have been able to dictate numbers and text into the cells of Excel 2016 using Nuance Dragon Professional Individual 15.30.000.006.

        As of yesterday, my ability to dictate into Excel is sporadic. I can dictate into new spreadsheets but not spreadsheets I have been using for several years.

        I did a computer update from Windows 10 professional 1809 to 1903 on December 23 and updated Microsoft Office Home and Business 2016 during the week of January 5.

        I also reinstalled and updated Dragon yesterday.

        The NatSpeak Excel Add-in shows as active when I go into Excel Options

        I have no problem dictating into new MS Word 2016 documents.

        I would appreciate any thoughts related to a workaround for using Dragon on older spreadsheets.

      • #2141160 Reply
        RetiredGeek
        AskWoody MVP

        Kathy,

        Are the workbooks you’ve been using for years still in the old .xls file format?

        Not sure if it is the problem but you might want to convert them to the newer format .xlsx for standard workbooks and .xlsm for those containing macros (VBA code).

        HTH 😎

        May the Forces of good computing be with you!

        RG

        PowerShell & VBA Rule!
        Computer Specs

      • #2141200 Reply
        Kathy Stevens
        AskWoody Plus

        RetiredGeek

        The workbook in question was started in 2006 and has been periodically modified and updated daily since then. It contains a huge amount of data, a large number of formulas and links, and is currently in the .xlsx format.

        It appears that my problem lies within the workbook itself.

        I just opened a new .xlsx formatted Excel 2016 spreadsheet and Dragon had no problem entering text and numbers in cells of the new workbook.

        I guess the next step is to copy the old sheets and paste them into a fresh workbook and see if that solves a problem.

        As an alternative, I could convert the file to a database.

        • #2141240 Reply
          Kirsty
          Da Boss

          Before delving too deeply into changes, Kathy, what about trying to change the file suffix, to .xlsx, and see if that makes any difference? (or checking it is with that format – I see your comment that it is in that “format”, which I presume means it isn’t showing as “compatibility mode”).

          • This reply was modified 4 months, 3 weeks ago by Kirsty.
          1 user thanked author for this post.
      • #2141260 Reply
        Kathy Stevens
        AskWoody Plus

        Kirsty

        Thank you for getting back.

        The file name already is XXXX.xlsx

        I will check for “compatibility mode” when I get a chance.

        • #2141273 Reply
          Kirsty
          Da Boss

          In that case, it may be worth trying a “Save As”, and giving it a new filename with the .xlsx suffix – it may possibly help… 🙂

          1 user thanked author for this post.
      • #2141297 Reply
        Kathy Stevens
        AskWoody Plus

        Renaming the file did not work.

        Thanks for the idea

        • #2141356 Reply
          Kirsty
          Da Boss

          Kathy, do you still have an older version of Office/Excel installed? If so, I’d give it try with that.

          Alternative suggestions might include copying the worksheet/s into a new workbook…?

          1 user thanked author for this post.
      • #2141413 Reply
        Kathy Stevens
        AskWoody Plus

        Kirsty

        Unfortunately, when we installed Microsoft Office 2016 it required the removal of our earlier versions of Office. We still have the old Office discs but are not inclined to attempt to reinstall the earlier versions for now.

        Tried copying the workbook into a clean Excel sheet but ran into problems with formatting and we were still unable to use Dragon Naturally Speaking for data entry.

        Thanks for your thoughts.

        1 user thanked author for this post.
        • #2142048 Reply
          Kirsty
          Da Boss

          You’re probably getting fed up with trying things Kathy, but I have one further suggestion that might be worth a look at…
          Save a copy of the file (so you still have an original safely tucked away, just in case), then try:
          File> Open> Open & Repair (a down-arrow option)> Repair (you could try Cxtract Data instead on a second attempt).
          🙂

          1 user thanked author for this post.
      • #2142102 Reply
        Kathy Stevens
        AskWoody Plus

        Kirsty

        Thanks for following up.

        I have tried the open repair routine that you suggested but for some reason I have been unable to get to the Open & Repair option.

        I will try again later.

        Thanks again

        1 user thanked author for this post.
    Viewing 6 reply threads

    Please follow the -Lounge Rules- no personal attacks, no swearing, and politics/religion are relegated to the Rants forum.

    Reply To: Excel 2016 vs. Dragon Professional 15

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.

    Cancel