#VALUE! is displayed in data area

When you click Work Offline from the Login dialog box, the workbook can initially show #VALUE! in the data cells because of an Excel issue. You can refresh the data while offline using these methods:

To refresh the entire workbook at the same time, press Ctrl + Alt + F9 on the keyboard.

To refresh one worksheet at a time, force a recalculation of the data. One way to force a recalculation is to specify the name of an off-grid dimension member.

#VALUE! is displayed for certain members of previously spevcified data if you changed the dataset to exclude those members and then refreshed the workbook. To restore the values, change the dataset to include the members and then click Refresh.