transaction log?
 

Is there a simple way to log transactions?

Our municiaplity has been encouraging managers to automate which has
resulted in many creating Excel spreadsheets to store and display
data. They are not logging transactions (ie changes) so when the
auditor tries to figure out what's been going on there is no computer
record.

I've looked in the MS Excel manaul for a feature which logs
spreadsheet changes without success. Has anyone a solution, preferably
simple and easy to use, to this problem?

Thanks.

transaction log?
 

Not many people like this querky feature BUT you could 'Share Workbook'.
[From the top menu select ToolsShare Workbook]
Then 'ToolsTrack Changes' will keep track of changes to the workbook.
But, like I say, I've heard a LOT of horror stories about this feature
causing bad issues with the workbook AND had 2 bad experiences myself. Use
the Share feature at your own risk.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown


"Wm Watt" wrote:

Is there a simple way to log transactions?

Our municiaplity has been encouraging managers to automate which has
resulted in many creating Excel spreadsheets to store and display
data. They are not logging transactions (ie changes) so when the
auditor tries to figure out what's been going on there is no computer
record.

I've looked in the MS Excel manaul for a feature which logs
spreadsheet changes without success. Has anyone a solution, preferably
simple and easy to use, to this problem?

Thanks.