Smart View Client 720
SummaryWipe out Formula with Hard code member
I am using Excel 2016 and currently using smart view client 710. I created a report that uses formula to pick up member for refresh. Example, I have a sheet that allows user to select the year they wanted to view the data and the smart view report will have a link to that input that picks up the year.
For users that are using client 710, they have no problem refreshing this report. But for users who are using smart view 720, they notice that weird things happen when they refresh it. The cells that contain the formula will either change (example from $C$