H
henryjvv
How do I prevent excel from tracking changes in a workbook withou
unsharing the workbook
unsharing the workbook
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
It looks like you could:
Tools|Share workbook|advanced tab
and check "don't keep change history"
Tools|Share workbook|advanced tab
and check "don't keep change history"
B
Ben Blaney
Dave said:It looks like you could:
Tools|Share workbook|advanced tab
and check "don't keep change history"
It seems to remember a bunch of stuff, anyway. I have two shared
workbooks, and the filesize grows at a remarkable rate. They start
off around 250KB, and two weeks later they hit 2MB.
Suggestions?
D
Dave Peterson
Maybe the lastcell in the worksheets is way past what you think it should be.
(although that's one big leap).
If you hit ctrl-end, you go to the bottom left corner of the used range.
If that's way past what you think it should be, you can visit Debra Dalgleish's
site to see some ways to try to reset that lastused cell.
http://www.contextures.com/xlfaqApp.html#Unused
I don't use shared workbooks (or track changes) enough (ever!) to offer any real
help.
Sorry.
(although that's one big leap).
If you hit ctrl-end, you go to the bottom left corner of the used range.
If that's way past what you think it should be, you can visit Debra Dalgleish's
site to see some ways to try to reset that lastused cell.
http://www.contextures.com/xlfaqApp.html#Unused
I don't use shared workbooks (or track changes) enough (ever!) to offer any real
help.
Sorry.
B
Ben Blaney
Dave said:Maybe the lastcell in the worksheets is way past what you think it should be.
(although that's one big leap).
If you hit ctrl-end, you go to the bottom left corner of the used range.
If that's way past what you think it should be, you can visit Debra Dalgleish's
site to see some ways to try to reset that lastused cell.
http://www.contextures.com/xlfaqApp.html#Unused
I don't use shared workbooks (or track changes) enough (ever!) to offer any real
help.
Sorry.
That's a great start - thanks Dave.
TBH, I'm thinking of lobbing the lot into Access, but I just don't
have time to do it right now.