+ Reply to Thread
Results 1 to 6 of 6

Office Pro Plus 2016 formulas issue

  1. #1
    Registered User
    Join Date
    08-28-2017
    Location
    Ireland
    MS-Off Ver
    2016
    Posts
    3

    Office Pro Plus 2016 formulas issue

    Hello All,
    I have recently upgraded from office 2010 to office pro plus 2016. I am seeing an issue with Formulas on Excel spread sheets coming up with the error #values! in all the sheets. It works fine in Excel 2010. It works fine when in preview mode in Pro Plus 2016. As soon as select to edit it breaks with the value error. . The file is Microsoft Excel Worksheet (.xlsx) file. Is there any setting that needs to be configured on our new Pro Plus install?? The links are only to other tabs in the work book and not to any external source.
    I have tried every setting i can think of at this stage and also googled everything possible, happening on a few files now

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Office Pro Plus 2016 formulas issue

    Show formula (s)
    Try Control+Shift+Enter
    Attach example excel file with the problem

  3. #3
    Registered User
    Join Date
    08-28-2017
    Location
    Ireland
    MS-Off Ver
    2016
    Posts
    3

    Re: Office Pro Plus 2016 formulas issue

    Thanks
    File should be attached now
    cheers
    Attached Files Attached Files

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Office Pro Plus 2016 formulas issue

    you need update your external links
    =SUMIF('C:\Users\40300950\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\2ZHFLHBN\[HCL Estimate_Q2335864_SCCM_for_PGCS_Project_04192017.xlsx]One-Time HW & SW'!$A$6:$A$142,'C:\Users\40300950\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\2ZHFLHBN\[HCL Estimate_Q2335864_SCCM_for_PGCS_Project_04192017.xlsx]Executive Summary'!$C7,'C:\Users\40300950\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\2ZHFLHBN\[HCL Estimate_Q2335864_SCCM_for_PGCS_Project_04192017.xlsx]One-Time HW & SW'!C$6:C$142)

    If you open excel file from Outlook and link to this file without saving it's temporary link.
    save file from outlook on eg. Desktop and re-link
    Last edited by sandy666; 08-28-2017 at 10:43 AM.

  5. #5
    Registered User
    Join Date
    08-28-2017
    Location
    Ireland
    MS-Off Ver
    2016
    Posts
    3

    Re: Office Pro Plus 2016 formulas issue

    Hi Sandy,
    Thanks very much for your help. That worked changing the reference link to the original file that it was created with,
    Strange as only needed to be updated using 2016 and not excel 2010. Looks like i will need to do it for certain file
    Thanks again

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Office Pro Plus 2016 formulas issue

    You are welcome.

    Probably with 2010 there was still temporary file.
    After install 2016 temp folder was cleaned and you lost connection.
    I suggest never use temporary files if you don't like troubles

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 12-18-2016, 11:47 PM
  2. Replies: 1
    Last Post: 08-07-2016, 05:52 PM
  3. [SOLVED] Code not working in Office 2010 and Office 2016
    By amitmodi_mrt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-21-2016, 02:48 PM
  4. Replies: 2
    Last Post: 05-24-2016, 10:43 PM
  5. What's New and Improved in Office 2016 for Office 365
    By AlKey in forum The Water Cooler
    Replies: 5
    Last Post: 05-06-2016, 07:52 AM
  6. Conditional formatting with udf issues with Office 2016 / Office 365
    By andikeep2580 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-22-2016, 10:58 AM
  7. Update from Office 97 to Office Professional Plus 2016
    By billd73 in forum Excel General
    Replies: 0
    Last Post: 12-28-2015, 05:15 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1