Shared workbook - Save history tab?

[smurphy812]

I've shared a workbook, tracked the changes to a new worksheet, printed the changes, and now I want to save the "history" worksheet that Excel automatically generated. Does anyone know if this is possible.

Thanks so much!
Sydni

[Bryan Hessey]

I've shared a workbook, tracked the changes to a new worksheet, printed the changes, and now I want to save the "history" worksheet that Excel automatically generated. Does anyone know if this is possible.

Thanks so much!
Sydni

In Tools, TrackChanges, Highlight Changes, is a 'List to Sheet'

this sheet is then a standard Worksheet and you can Edit - Move or Copy etc

hth
---

[smurphy812]

I've done this, but when I save the file the worksheet doesn't save with the file. I have to regenerate the next time the file is opened. Any ideas?

Thanks!
Sydni

[Bryan Hessey]

I've done this, but when I save the file the worksheet doesn't save with the file. I have to regenerate the next time the file is opened. Any ideas?

Thanks!
Sydni

Hi,

The 'Track' is rather guarded in allowing access to it's data, one possibility for you is if you record a macro, and replace the code with

Please Login or Register  to view this content.

and in Macro, Options set to a ShortCut key (like Ctrl/Shift/H for 'History') then, with the History in view, press CTRL/SHIFT/H the data will be copied to a new sheet, this sheet will save with the workbook.

Note, you will need to take the workbook off 'Share' to do the macro setup, but it will run as a ShortCut.

Let me know how you go.
---

[smurphy812]

Bryan,

Thanks for the reply. I think this will work. I've tested breifly and all appeared as it should.

Thanks again!
Sydni