Software

Ask something
Discussion Locked

MS Excel Question

0 helpful
3 replies

by brianaaa12

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a client who uses Excel to track contributions during a 'Share-a-Thon'. Within their Excel file they have different pages that format the data in different ways.

I have a couple questions regarding this.

1) Is there a way to make Excelsave the file on a regular basis (not the recovery file) so others can open it at any given time and see a relatively current sheet?
2) If another user had the file open simultaneously in read-only mode, is there a way for it to update itself periodically without exiting and restarting the program?

What the station manager would like to be able to do is have the file open at a LAN workstation in the studio (this is for a religous radio station) and see current stats for donations.

If anybody has any suggestions, please pass them along.

Brian

3 replies

by dklippert

Look at Tools>Share Workbook.
Type AutoSave into the Help file question box.
Try using F9 to update the spreadsheet.

This discussion is closed to new replies.