Full Refresh for current sheet only option

Posted 5 months ago by Tom Roberts

T
Tom Roberts
Implemented

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

Sorted by
Damien Zwillinger

Damien Zwillinger posted 3 months ago Admin

This has been delivered in NX 2024.7. Please let us know about your experience. Thanks!

0 Votes

Damien Zwillinger

Damien Zwillinger posted 5 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 Lewis posted 5 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