Forum Discussion
I don't see my pivot tables in my slider.
If you have tried all of the steps you mentioned and your pivot tables are still not showing up in the slider, here are a few additional things you can try:
- Check if the pivot tables are in the same workbook as the slider. If they are in a different workbook, they may not show up in the slider.
- Make sure that the pivot tables are not hidden or filtered. If a pivot table is hidden or filtered, it will not appear in the list of available pivot tables in the slider.
- Check the format of the pivot tables. If the pivot tables are in a different format or layout, they may not appear in the slider.
- Try creating a new slider and see if the pivot tables show up in the new slider. If the pivot tables show up in the new slider, there may be an issue with the original slider.
- Make sure that the pivot tables are not corrupted. If a pivot table is corrupted, it may not show up in the slider.
Regarding your question about creating one slider per sheet, it is possible to do so if you want the same functionality on each sheet. However, you may also want to consider using a single slider that is linked to all of the pivot tables in the workbook, as this can be more efficient and easier to manage.
If you have tried all of the steps you mentioned and your pivot tables are still not showing up in the slider, here are a few additional things you can try:
- Check if the pivot tables are in the same workbook as the slider. If they are in a different workbook, they may not show up in the slider.
- Make sure that the pivot tables are not hidden or filtered. If a pivot table is hidden or filtered, it will not appear in the list of available pivot tables in the slider.
- Check the format of the pivot tables. If the pivot tables are in a different format or layout, they may not appear in the slider.
- Try creating a new slider and see if the pivot tables show up in the new slider. If the pivot tables show up in the new slider, there may be an issue with the original slider.
- Make sure that the pivot tables are not corrupted. If a pivot table is corrupted, it may not show up in the slider.
Regarding your question about creating one slider per sheet, it is possible to do so if you want the same functionality on each sheet. However, you may also want to consider using a single slider that is linked to all of the pivot tables in the workbook, as this can be more efficient and easier to manage.