Apr 12 2023 09:25 AM
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.
Apr 12 2023 11:03 AM
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?
Apr 12 2023 12:34 PM
Apr 12 2023 01:05 PM
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.
Apr 18 2023 06:54 AM