Forum Stats

  • 3,854,773 Users
  • 2,264,421 Discussions
  • 7,905,782 Comments

Discussions

Open as smart view - excel opens but protects worksheet - and after unlock cannot use to submit data

Teresa Modesta
Teresa Modesta Member Posts: 313
edited Jan 20, 2020 1:34AM in Planning and Budgeting

Hi,

as anyone experienced this behaviour in PBCS.

1. User opens form via task list

2. Form allows user input

3. User users shortcut menu to open in smart view

4. Excel opens, but with the sheet in a protected state

5. User turns off the protected state using standard excel functionality

6. Smart View sheet cannot then be used to input data from

Any idea who to change the outcome at 4, such that excel is not protected and the smart view grid can be used for data input, and yes I know you can open the web forms directly from smart view.

thank you for any useful suggestions,

Teresa.

Tagged:

Answers