I am using transactions sheet to populate then it goes to a Pivot table. My problem is: I recovered a copy of the worksheet from a month ago. But the “Description” does not populate it says
=HYPERLINK("#rangeid=1379663389",“Description”)
when I try to change the Description. I says invalid. I went to the transaction page because it is not populating precedes the pivot table.
I gather the formula is wrong, but not sure how to make it right.