Skip to Content
0

EPM offline mode issue

Jan 25 at 06:29 PM

78

avatar image

Struggling with offline mode for an input form.

Idea is that we'd take the input form offline, an individual fills it out, then sends it back and we save the data.

I first tried just taking it offline, but the cells I need them to fill in are locked.

I then tried checking the below boxes to keep them unlocked, which worked, but as soon as I turned the file back online, it give me a message box saying "You can't undo deleting sheets, and you might be removing some data. If you don't need it, click Delete". So it appears the delete the "offline copy" of that worksheet and all the inputs are deleted and the worksheet is reverted back to it's original state.

Note that the cells I'm looking to have them update are cells that are excel formula's grabbing information from EPM reports in the same worksheet. There is then another 'input form' in the worksheet that feeds from the cells that are updated.

Thanks in advance.

capture.png (18.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Jan 25 at 07:23 PM
0

Static Offline Without Protection - just for reports, NOT for Input Forms

Standard procedure:

1. Unlock cells required for input - using formatting sheet or in case of static report - just using Excel formatting.

2. Protect Sheet using EPM protection in sheet options.

3. Set workbook offline.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
0

Thanks so much!

0