List

[paitchison]

I am a relative beginner at Excel (compare to many that inhabit this board). I am setting up a 'Snack Shack' "point of sale / order fill" spreadsheet to be used in our church kitchen (Holy Grille). I need all of the relevent current information to remain visible on the main screen.

I am using Excel 97, and a Winows 98 PII laptop computer with a remote monitor and wireless mouse. This allows the cook staff to enter data when orders are filled.

My problem is that the "List" function (Data/Valadation/list/source) will not work above the Window/Freeze pane. It works perfectly below the Window/Freeze pane. Can the "List" function be enabled to work above Window/Freeze pane as well as below?

The spreadsheet is working out just fine otherwise.

Many Thanks Paul

 

[paitchison]

How does one get "Shared Workbook" to share faster than every 5 minites? I'm looking for a sharing update every 15 seconds or so.

 

[Joe Was]

ActiveWorkbook.AutoUpdateFrequency = 1

You can override the 5 min limit by putting this in the startup event.

 

[paitchison]

I've just been been able to get back to this project.
Sorry, for my stupidity Joe, but exactly how do I add this 'AutoUpdateFrequency' statement to the "startup event". I'm sure it's simple, but I haven't been able to get it to work. I'm using Excel 97.

 

[Joe Was]

Sorry, 5 minutes is the shortest update to sharing!
I thought the code would be in seconds, but alass it is minutes.



Private Sub Workbook_Open()
'ThisWorkbook module code, only!

'The AutoUpdateFrequency property must be,
'a value from 5 to 1440 minutes, only.

ActiveWorkbook.AutoUpdateFrequency = 5
End Sub