1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Auto expiration/lockdown of an excel file.

Hi,

I'm looking for a way to auto-expire an excel file. I want it to show a message saying to contact our department for the latest version and hide/lock every sheet if the file is opened e.g. 180 days after a set date.

It has to work in both desktop and online version as the file would be shared on company's sharepoint, so macros aren't an option as far as I know.

Everything that helps is appreciated!

submitted by /u/lobstereqpl
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel file
#auto expiration
#lockdown
#latest version
#hide sheets
#contact department
#file locking
#desktop version
#online version
#sharepoint
#expiry date
#version control
#macros
#message prompt