| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Web dependencies troubleshooting"
(Created page with "This page can help if you find that sheets do not update correctly when you change a parameter e.g. * Slicer * XL3Link * Unlocked cell == Symptom ==...") |
(→Solution) |
||
| (7 intermediate revisions by 4 users not shown) | |||
| Line 2: | Line 2: | ||
* [[Dimension_Slicers|Slicer]] | * [[Dimension_Slicers|Slicer]] | ||
* [[XL3Link]] | * [[XL3Link]] | ||
| + | * Chart | ||
* Unlocked cell | * Unlocked cell | ||
| − | == | + | == Symptoms == |
* You have a worksheet which allows a user to set the report parameters. | * You have a worksheet which allows a user to set the report parameters. | ||
* These drive grids or tables on another sheet. | * These drive grids or tables on another sheet. | ||
| Line 12: | Line 13: | ||
| − | XLCubed will attempt to work out the dependencies in your workbook, i.e. which grids need to be run for the visible sheet. This means not all grids | + | XLCubed will attempt to work out the dependencies in your workbook, i.e. which grids need to be run for the visible sheet. This means not all grids need to be run to display a sheet, improving performance. |
| − | If for some reason this | + | If for some reason this cannot be done then the grid may not refresh when required. |
| − | == | + | == Problem == |
| − | |||
| − | |||
We have a slicer connected to a [[Grid]] on Sheet2, and a formula displaying a number from that grid. | We have a slicer connected to a [[Grid]] on Sheet2, and a formula displaying a number from that grid. | ||
| Line 26: | Line 25: | ||
[[File:WebDepends2.png|thumb|none|Data page with Grid]] | [[File:WebDepends2.png|thumb|none|Data page with Grid]] | ||
| − | When this is published to the web the Indirect() formula means that the dependencies are not traced. We can add a formula to the front sheet to make sure the grid is refreshed when the main page is shown. | + | When this is published to the web the Indirect() formula means that the dependencies are not traced. |
| + | |||
| + | == Solution == | ||
| + | |||
| + | You can create a simple dependency to help out with this situation as seen in the below example. | ||
| + | |||
| + | We can add a formula to the front sheet to make sure the grid is refreshed when the main page is shown. | ||
[[File:WebDepends3.png|thumb|none|Data page with helper formula]] | [[File:WebDepends3.png|thumb|none|Data page with helper formula]] | ||
| − | We can format this new cell so that the test | + | We can format this new cell so that the test is not visible, e.g. by setting the number format to <code>;;;</code>. |
| + | |||
| + | Note that the formula references a cell in the grid, not somewhere outside the grid on that sheet. The cell referenced should be at the top/left of the grid, so the first Header item or data cells are good candidates. | ||
| + | |||
| + | The same technique can be applies to [[Tables]] - you could reference the table headers or the first row of data. | ||
| − | + | ==Manual Configuration== | |
| + | As of [[Version 9.1]] you can [[Customise_publishing_dependencies|configure]] the dependencies yourself. | ||
| − | + | [[Category: Troubleshooting]] | |
Latest revision as of 16:45, 30 July 2020
This page can help if you find that sheets do not update correctly when you change a parameter e.g.
Contents
[hide]Symptoms
- You have a worksheet which allows a user to set the report parameters.
- These drive grids or tables on another sheet.
- Formulae bring those numbers to the visible sheet.
- The numbers do not update when the selection is changed.
- But if you switch to the sheet with the grid on it then they do update.
XLCubed will attempt to work out the dependencies in your workbook, i.e. which grids need to be run for the visible sheet. This means not all grids need to be run to display a sheet, improving performance.
If for some reason this cannot be done then the grid may not refresh when required.
Problem
We have a slicer connected to a Grid on Sheet2, and a formula displaying a number from that grid.
When this is published to the web the Indirect() formula means that the dependencies are not traced.
Solution
You can create a simple dependency to help out with this situation as seen in the below example.
We can add a formula to the front sheet to make sure the grid is refreshed when the main page is shown.
We can format this new cell so that the test is not visible, e.g. by setting the number format to ;;;.
Note that the formula references a cell in the grid, not somewhere outside the grid on that sheet. The cell referenced should be at the top/left of the grid, so the first Header item or data cells are good candidates.
The same technique can be applies to Tables - you could reference the table headers or the first row of data.
Manual Configuration
As of Version 9.1 you can configure the dependencies yourself.
