Experiencing compatability issues with my spreadsheet


  1. Posts : 6
    windows 10 pro
       #1

    Experiencing compatability issues with my spreadsheet


    Greetings

    I am retired and learning to work with excel

    My interest is astronumerology

    I was given a excel workbook that was written in office 2016 excel however its not running on my office 201 and windows pro 10

    is there a way to get it to run

    kind regards

    Rajann
      My Computer


  2. Posts : 11,379
    Windows 10 Home x64 Version 21H2 Build 19044.1706
       #2

    Rajann,

    1 Excel 2016 has the same file format as Excel 2010 [which is what I think you meant by Excel 201]. So file format is not your problem. {Excel 2016 has the same file format as Excel 2019 as well}

    2 Irrespective of any use of VBA [see below], Excel 2010 does not have all the non-VBA functions that Excel 2016 has. By "functions" in this respect, I am referring to things that you might know as "formulas" because they are accessed by that tab name in the Excel Ribbon.

    3 It is possible that your reference to "running" indicates that this file probably executes a task for you using VBA code. If so, there are four relevant points -
    - Excel 2016 has almost the same VBA {user-accessible programming language, often just referred to as "macros"} as Excel 2010 but not quite. Excel 2016 VBA has additional functions which Excel 2010 VBA does not know about.
    - You will need to authorise the running of VBA code in your Excel - you need to "enable macros".
    - VBA can often require that particular standard code blocks ["References"} are set up.
    - Specialist tasks in Excel VBA are often created as or requiring the support of "add-ins" {custom, non-standard code blocks}.

    Apart from enabling macros [if relevant], you can only find out if any of the other factors are affecting your use of the Excel file by consulting its author.

    Denis
    Last edited by Try3; 31 Oct 2019 at 04:52.
      My Computer


  3. Posts : 6
    windows 10 pro
    Thread Starter
       #3

    Hi Dennis

    Many thanx for your response

    My mistake it Sud have read 2019

    Office 2019 is not running the sheet

    Regards

    Rajann
      My Computer


  4. Posts : 11,379
    Windows 10 Home x64 Version 21H2 Build 19044.1706
       #4

    Rajann,

    I have amended my previous post. Two of the factors are not relevant to running an Excel 2016 file in Excel 2019.

    Denis
      My Computer


  5. Posts : 6
    windows 10 pro
    Thread Starter
       #5

    hi denis

    may I send you the vba code if you may be able to help solve

    regards

    rajann
      My Computer


  6. Posts : 11,379
    Windows 10 Home x64 Version 21H2 Build 19044.1706
       #6

    - You will need to authorise the running of VBA code in your Excel - you need to "enable macros".
    - VBA can often require that particular standard code blocks ["References"} are set up.
    - Specialist tasks in Excel VBA are often created as or requiring the support of "add-ins" {custom, non-standard code blocks}.

    Apart from enabling macros [if relevant], you can only find out if any of the other factors are affecting your use of the Excel file by consulting its author.
      My Computer


  7. Posts : 11,379
    Windows 10 Home x64 Version 21H2 Build 19044.1706
       #7

    Unless you are in touch with other users of that Excel file. If their copies worked then you could compare your Excel & VBA settings to identify the problem.

    Denis
      My Computer


  8. Posts : 6
    windows 10 pro
    Thread Starter
       #8

    Hi Denis
    The sheet is working fot the gentleman that gave it to be

    he is using windows 10 home with office 2016

    Can I remove office 2019 and install 2016 will it work with my windows 10 pro

    regards

    Rajann
      My Computer


  9. Posts : 11,379
    Windows 10 Home x64 Version 21H2 Build 19044.1706
       #9

    Rajann,

    How on earth would I know? I do not know what is stopping it now.

    I advised you to enable macros and to consult the author. You will first need to ask whether the work is done by a set of Excel Functions or by VBA. If it is VBA then ask
    - VBA can often require that particular standard code blocks ["References"} are set up.
    - Specialist tasks in Excel VBA are often created as or requiring the support of "add-ins" {custom, non-standard code blocks}.

    Denis
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 02:41.
Find Us




Windows 10 Forums