Document Defaults

[Anonymous]

I need a sheet to open with the previous year selected. How can make it so every time the document is opened it opens to the previous years data?

[kenkuchana]

Go to Sheet Properties -> Add Actions on OnActiveSheet -> Add Action -> Select Action Type: Selection and Action: Select in Field -> Write the Year field name in Field box and write "=Year(AddYears(Today(),-1))" in Search String -> click OK -> click Apply