View Cell History not updating

I'm having an issue where the View Cell History is not updating as cells are filled and cleared. The Activity Log still updates as normal, but due to some people accessing the file not having a license, the Activity Log alone is not sufficient.

I've tried refreshing the sheet, and the 8th is the last day that was correctly added to the history.

Please let me know if you have any suggestions!

Find more posts tagged with

Sheets

functionality

Accepted answers

All comments

Jgorsich

If you are regularly using the cell history to extract meaningful information, you may want to consider automating duplicating any edits into a history sheet via the automation tool - this will allow more in depth analysis and pattern identification vs manually viewing the cell history. Just a thought though, my apologies for not having any info regarding the actual issue you are having!

Spencer_W

Thank you!

It's less that we need to regularly extract information, but more that every so often, we need to look back and see who made a certain update and to what value on a certain day.

After looking more in depth, it does seem to be an issue of capacity or something? The file has been in constant daily use since mid July last year. When I make a change on a new row, that hasn't been used before, the "View Cell History" windows updates like normal. Is there are way to "reset" the Cell History?

The solution I'm considering now would be to just duplicate static information into new rows, and deleting the rows that we have been using. My main issue with this is just that we use Cell Links to Other Sheets, so it would be a hassle to reset t

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.