Timestamp in Microsoft Teams Excel tab is so unstable

Bill Pace 0 Reputation points
2026-10-31T16:54:53.1033333+00:00

I cracked the code to locking in the timestamp on teams. You can't use VBA or Macros in teams, i figured out how to stop teams from updating whenever someone opens the file in teams. Curious if anyone is still having issues with this?

Microsoft Teams | Microsoft Teams for business | Teams and channels | Other
0 comments No comments

1 answer

Sort by: Most helpful
  1. KAMRAN ALI 320 Reputation points
    2026-10-31T17:16:04.7966667+00:00

    Hi Bill,

    Welcome to the Microsoft Q&A forum. That is a fantastic workaround to share with the community! Timestamp stability in Excel for the Web and Microsoft Teams tabs is a massive pain point for many users, primarily because volatile functions like NOW() or TODAY() recalculate automatically every time a user opens or co-authors the file.

    Since VBA macros do not execute natively in Excel for the Web, users frequently run into this exact limitation. Here are the primary ways this issue is typically addressed in Teams and Excel Online environments:

    1. Iterative Calculation (Circular References Workaround):
      • Go to File > Options > Formulas in the desktop app (or enable calculation settings).
      • Enable Iterative Calculation.
      • Use an IF formula targeting the cell itself: =IF(A2<>"", IF(B2="", NOW(), B2), "").
      • Note: This prevents the timestamp from changing once populated, though it relies on formula calculation settings remaining consistent across users.
    2. Office Scripts (TypeScript Automation):
      • Unlike VBA, Office Scripts run natively in Excel for the Web and Microsoft Teams tabs.
      • Users create a simple script that pastes the static value of =NOW() into a target cell upon a specific trigger or button click.
      • This guarantees a completely static timestamp without risking volatile recalculations.
    3. Power Automate Flow Integration: Setting up a Power Automate flow triggered by an item edit or form submission inserts an unchangeable, server-side timestamp directly into the Excel table.

    Thank you for contributing your insights to the forum! Please feel free to share the details of the specific formula or method you used in the comments below so other community members facing this issue can benefit from your solution.

    If this response is helpful, please consider clicking Accept Answer and upvoting it.

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.