Monday, July 4, 2016

Prevent Excel from Refreshing Data When Copying and Pasting


When copying dynamic data out of excel when pasting the value pasted changes.


Change the setting in excel to perform automatic calculations:

File tab -> options -> Formulas side tab -> Under the calculation Options, workbook calculation, select manual. Optionally you can shut off recalculate workbook before saving depending on situation.

Co-worker and tested with my own application.

Wednesday, June 29, 2016

Recursively Reset Permissions in Windows Path Using iCacls


Need folders and files under a specific folder to regain all inheritance from the specified folder.


Run the icacls with the recursive and reset switches:

icacls <folder> /reset /t

/t = recursive
/reset removes any modifications from inheritance in the ACL. By default, folders will inherit their permissions from the folder above them.

The final step in this is to give the primary folder that you want to push inheritance from down through the folders the appropriate permissions, all child folders will then have access as intended.

Primary Source: