+ Reply to Thread
Results 1 to 11 of 11

Excel 2013 Formulas Show Zeros Instead Of Calculating. Works In Excel 2007-2010.

  1. #1
    Registered User
    Join Date
    08-15-2013
    Location
    Vancouver, BC
    MS-Off Ver
    Excel 2013
    Posts
    6

    Excel 2013 Formulas Show Zeros Instead Of Calculating. Works In Excel 2007-2010.

    Attachment 258197I have a problem that may be hard to describe. I'll do my best to explain what is going on.

    1) I have a document created that is running in compatibility mode Excel 97-2003.

    2) This document is on a shared folder and is shared with multiple computers.

    3) The formulas show all zeros when the document is opened in Excel 2013

    4) The formulas work correctly *Formulas calculate a result* when the document is opened in Excel 2007 and Excel 2010.

    5) Periodically the formulas work correctly in Excel 2013.

    Here is a picture of what is occurring:
    Attached Images Attached Images
    Last edited by Onihonker; 08-15-2013 at 04:54 PM.

  2. #2
    Registered User
    Join Date
    05-21-2009
    Location
    Austin, TX
    MS-Off Ver
    Office 2010
    Posts
    10

    Re: Excel 2013 Formulas Show Zeros Instead Of Calculating. Works In Excel 2007-2010.

    Do other spreadsheets work ok?
    Is Automatic calculations turned off?

  3. #3
    Registered User
    Join Date
    08-15-2013
    Location
    Vancouver, BC
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Excel 2013 Formulas Show Zeros Instead Of Calculating. Works In Excel 2007-2010.

    Do other spreadsheets work ok?
    Other worksheets within the spreadsheet work 100%. Only the one worksheet seems to have this issue.

    Is Automatic calculations turned off?
    This is turned on.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,213

    Re: Excel 2013 Formulas Show Zeros Instead Of Calculating. Works In Excel 2007-2010.

    Hi and welcome to the forum

    have you even looked at the picture you attached??? I would need a magnifying glass to try and make anything out in it!!

    Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Excel 2013 Formulas Show Zeros Instead Of Calculating. Works In Excel 2007-2010.

    Quote Originally Posted by FDibbins View Post

    have you even looked at the picture you attached??? I would need a magnifying glass to try and make anything out in it!!
    I hear ya!

    On my monitor if I set the screen resolution as high as it will go (1920 x 1080) text looks like it's about a size 2 font!
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  6. #6
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Excel 2013 Formulas Show Zeros Instead Of Calculating. Works In Excel 2007-2010.

    fwiw a bit bigger
    but op could have clicked in at least on cell with a formula in so it was in the formula bar
    Attached Images Attached Images
    Last edited by martindwilson; 08-15-2013 at 08:31 PM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  7. #7
    Registered User
    Join Date
    08-15-2013
    Location
    Vancouver, BC
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Excel 2013 Formulas Show Zeros Instead Of Calculating. Works In Excel 2007-2010.

    Quote Originally Posted by FDibbins View Post
    Hi and welcome to the forum

    have you even looked at the picture you attached??? I would need a magnifying glass to try and make anything out in it!!

    Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    I apologize for the difficulty viewing the photo. *my first post on these forums so still learning how to best communicate my problem* I knew this one would be difficult to describe so please bear with me.

    We use this spreadsheet to for work and it keeps track of all of our financial information and I didn't want to post it on the internet. Thought a photo showing columns of all zeros would have been enough at first. I was wrong.

    Do you guys suggest I post a copy of the spreadsheet but with random sample values? Would this help.

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,213

    Re: Excel 2013 Formulas Show Zeros Instead Of Calculating. Works In Excel 2007-2010.

    Yes, a sample workbook with dunny data would be great, then we can play around with it. Include some sample answers if you can?

  9. #9
    Registered User
    Join Date
    08-15-2013
    Location
    Vancouver, BC
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Excel 2013 Formulas Show Zeros Instead Of Calculating. Works In Excel 2007-2010.

    Quote Originally Posted by FDibbins View Post
    Yes, a sample workbook with dunny data would be great, then we can play around with it. Include some sample answers if you can?
    I'll start working creating a file with sample data and post it as soon as I can.

  10. #10
    Registered User
    Join Date
    08-15-2013
    Location
    Vancouver, BC
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Excel 2013 Formulas Show Zeros Instead Of Calculating. Works In Excel 2007-2010.

    Still working on getting a working copy of the spreadsheet done up. In the meantime I think this may have something to do with my problem

    "Removed Records: Object from /xl/printerSettings/printerSettings11.bin part (Print options)"

  11. #11
    Registered User
    Join Date
    08-15-2013
    Location
    Vancouver, BC
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Excel 2013 Formulas Show Zeros Instead Of Calculating. Works In Excel 2007-2010.

    Here is the sample workbook as requested.

    Second worksheet should show zeros for all of the columns when opened in any version of Excel 2013. Please confirm.
    Attached Files Attached Files

+ 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. [SOLVED] Excel macro works in 2010 but nothing happens in 2007
    By onbeillp111 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2013, 08:46 AM
  2. Why and If statement works in Excel 2007 but fails to work in Excel 2010?
    By Superfly1984 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-03-2013, 08:26 AM
  3. [SOLVED] Creating scattering chart in excel 2007/2010/2013
    By elad.edri in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-22-2013, 10:02 AM
  4. Replies: 3
    Last Post: 03-29-2013, 12:35 PM
  5. code that works fine in excel 2007 ie ver 7 not in excel 2010 ie ver 9
    By ycg0311 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-25-2012, 11:56 AM

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