I exported a list of SharePoint issues into an Excel workbook (2010). The workbook seemed to work normally as I added new columns and formulae until just now. Now when I add a variance calc formula in a cell I see only the formula.
The formula is in a format like "=([@[Prior Est]]-[@[Actual (3/27)]])" instead of "=(G2-F2)" and nothing I do seems to get it to show the actual value.
Is there some sort of bug in the SharePoint excel exports after so many columns are added, or what?
View Complete Post