"Problems came up in the following areas during load: Worksheet setting" Error when attempting to export Departments to Excel

Document ID : KB000048032
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Departments, Department Resources, Export to Excel (Data Only) and save the file. When you try to open the file you get and error "Problems came up in the following areas during load: Worksheet setting".

Steps to Reproduce:

  1. Home, Department
  2. Select a Department OBS Unit
  3. Click Resources link
  4. Click the Resource icon
  5. Export to Excel (Data Only)
  6. Save the file
  7. Try to open the file

Expected Result: Export to Excel of Departments, Department Resources should work. Excel file should open fine.
Actual Result: Export to excel of Departments, Department Resources does not work. Excel file can not be opened

Solution:

WORKAROUND:
None.

STATUS/RESOLUTION:
CLRT-73367
Resolved in CA PPM 14.1