Forum Discussion

Elayne_Neal175's avatar
Elayne_Neal175
Copper Contributor
Apr 12, 2023

Excel Not Calculating on a Spreadsheet with Other Sections That Were Calculated Correctly

I have a spreadsheet where I copied several spreadsheets with formulas all calculated correctly and still calculating. I added a new section using the same formulas but they do not calculate and across (they show VALUE) or down. The bottom total is an Auto Sum. The horizontal totals are are a list of cells. I have copied the formula from above (still doesn't work) and searched online for similar problems and tried looking at all the icons and Excel Preferences set up and cannot find a solution to this issue.

excel

4 Replies

Sort By
  • mathetes's avatar
    mathetes
    Silver Contributor
    Apr 12, 2023

    Elayne_Neal175 

     

    Is it possible for you to post a copy of the spreadsheet on OneDrive or GoogleDrive with a link here that grants access to the file?

    • Elayne_Neal175's avatar
      Elayne_Neal175
      Copper Contributor
      Apr 12, 2023
      Where is the link? I will post a portion the spreadsheet since the information is confidential.
      • mathetes's avatar
        mathetes
        Silver Contributor
        Apr 12, 2023

        Elayne_Neal175 

         

        You have to post the link yourself after putting the anonymized copy of the spreadsheet on OneDrive or GoogleDrive...once you put the copy in one of those two spots, you paste a link here that grants access. And, yes, by all means, remove or make anonymous any portion that is confidential.

Resources