Forum Discussion
Formula not staying
Hello community! I am having trouble with my worksheet. It is not keeping my formula for adding number from different worksheets. The formula that I am trying is: ='1'!C12+'2'!C12+'3'!C12+'4'!C12+'...
Are you by any chance (perhaps accidentally) saving the file as a CSV file? If so, that explains your issue, since CSV files don't maintain formulas or formats. All becomes text.
Save your file as an Excel Workbook that gets the extension XLSX. Does that resolve the problem?