A multi-page Excel Link report contains several Controller functions on every worksheet. In order to improve performance when running the report, how should the functions be organized in the report?

Question

Options

• AName the worksheets in alphabetical order and insert all functions on the last Excel worksheet.
• BName the worksheets in alphabetical order and insert all functions on the first Excel worksheet
• CFunctions should be split evenly between worksheets, and hidden in system columns A. B, and
• EFunctions should be split evenly between worksheets. and hidden in system rows 1 to 27.

• A
  5% (2)
• B
  70% (28)
• C
  18% (7)
• E
  8% (3)

No community discussion yet for this question.