It would be extremely helpful to have an option to refresh a single sheet at a time. While building a complex multi sheet workbook doing a full refresh or even a smart refresh while building out new reports is time-consuming as everything needs to be recalculated.
With the recently added functions that can show when a workbook was last updated would it be possible to add that down to a worksheet level?
=== Please type above and preserve the below information ===
Name: Roberts, Tom
Excel version: PC 16.0.17328.20282
Connection: MADD
1 Votes
3 Comments
Sorted by
Damien Zwillingerposted
6 months ago
Admin
This has been delivered in NX 2024.7. Please let us know about your experience. Thanks!
0 Votes
Damien Zwillingerposted
7 months ago
Admin
Hi Tom
This was such a great timing, as work had already started on this feature.
The ability to refresh a workbook or a sheet should be in the product in our next release: 2024.6.
Stay tuned!
1 Votes
H
Harry Lewisposted
7 months ago
Admin
Hi Tom.
We, too, think that is a fantastic idea! Currently, when Excel recalculates, not only does it calculate the entire workbook, it also calculates EVERY open workbook.
We are currently investigating methods by which we can access that Excel functionality, but in a way where we could control the scope of that process.
We also really like your idea about being able to tell when a specific worksheet was last updated. Thanks for that.
1 Votes
It would be extremely helpful to have an option to refresh a single sheet at a time. While building a complex multi sheet workbook doing a full refresh or even a smart refresh while building out new reports is time-consuming as everything needs to be recalculated.
With the recently added functions that can show when a workbook was last updated would it be possible to add that down to a worksheet level?
=== Please type above and preserve the below information ===
Name: Roberts, Tom
Excel version: PC 16.0.17328.20282
Connection: MADD
1 Votes
3 Comments
Damien Zwillinger posted 6 months ago Admin
This has been delivered in NX 2024.7. Please let us know about your experience. Thanks!
0 Votes
Damien Zwillinger posted 7 months ago Admin
Hi Tom
This was such a great timing, as work had already started on this feature.
The ability to refresh a workbook or a sheet should be in the product in our next release: 2024.6.
Stay tuned!
1 Votes
Harry Lewis posted 7 months ago Admin
Hi Tom.
We, too, think that is a fantastic idea! Currently, when Excel recalculates, not only does it calculate the entire workbook, it also calculates EVERY open workbook.
We are currently investigating methods by which we can access that Excel functionality, but in a way where we could control the scope of that process.
We also really like your idea about being able to tell when a specific worksheet was last updated. Thanks for that.
-Harry
0 Votes
Login or Sign up to post a comment