Multiple Sheets Quick Link

[Jailbreak Heart]

When trying to use this facility only one of the sheets is updating, whichever one has the arrow pointing to it. What am I missing to make sure all the requested sheets are updating?

[GaryRussell]

Are you clicking "Start logging" next to one of the sheets or are you clicking this this button at the bottom of the form? You need to be clicking the button at the bottom of the form (next to the save and close button).

[Jailbreak Heart]

Yes, unfortunately any additional sheets open as read-only, locked for editing. Nothing to do with the properties of the worksheet.

I click only once but it opens a read-only copy of the requested file, and a read-only copy of any other excel file already open ...

[GaryRussell]

It's probably opening a read only version of the spreadsheet because you already had it open. When you use this feature it is important that all spreadsheets are closed first. It opens them for you.