'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Automatically Record Username and Timestamp in Excel for the Web
Question details
User needs a way to automatically log the username and timestamp beside a newly entered remark in Excel for the web.
- Product
- Excel for the Web
- Device & OS
- not provided
- Scenario
- Tracking user changes and adding automatic timestamps when remarks are entered in a shared web workbook.
- Observed behavior
- Excel for the web does not support VBA macros, preventing traditional macro-based automation from running and placing user details next to remarks.
Ensure you have access to Microsoft Power Automate or the desktop version of Excel, as VBA macros are strictly unsupported in the browser-based version of Excel.
Automate Timestamping using Power Automate
Since VBA is not supported in Excel for the web, Power Automate is the most effective cloud-based alternative to monitor changes and log user details automatically.
Power Automate can run in the background, monitoring your Excel tables for new entries or modifications, and automatically write the modifier's details into specific columns.
Open your workbook in Excel for the web. Ensure your data (including the remarks column and empty columns for Username and Timestamp) is formatted as a formal Excel Table (Insert > Table).
Log into Power Automate. Click 'Create' and select 'Automated cloud flow'. Choose the trigger 'When a row is created or modified' under Excel Online (Business).
In the flow setup, select the Location (OneDrive or SharePoint), the Document Library, the specific File, and the Table you created earlier.
Add a new step: 'Update a row' (Excel Online). Map the Key Column to identify the row, then click into the Username and Timestamp fields. Select dynamic content like 'Modified By Display Name' and 'Modified' (timestamp) to fill these fields.
Save your flow. Return to Excel for the web, type a new remark in your table, and wait a few moments for Power Automate to populate the username and timestamp.
Use Desktop Excel with a VBA Macro
If your team can access the desktop application, you can use a traditional VBA Worksheet_Change event to record timestamps.
Experience Robust Macro Support with WPS Office
VBA limitations in web browsers can disrupt your team's workflow automation. If you rely heavily on macros, WPS Office provides a powerful, lightweight, and free desktop alternative with excellent VBA macro support and seamless compatibility with Microsoft Excel formats.
Frequently Asked Questions
Why doesn't my VBA code work in Excel for the web?
Excel for the web simply does not support VBA macros. While you can store and view macro-enabled workbooks (.xlsm) in the browser, the VBA code cannot be executed unless the file is opened in the desktop version of Excel.
Can I use Office Scripts instead of VBA in Excel for the web?
Yes, Office Scripts (using TypeScript) are supported in Excel for the web for enterprise users. You can write a script to record timestamps, but unlike VBA's Worksheet_Change event, Office Scripts typically require manual execution or need to be triggered by a Power Automate flow.
Will the Power Automate method work for all users editing the web file?
Yes. Once the Power Automate flow is set up and attached to the shared Excel table, it runs in the cloud. It will automatically trigger and log the details regardless of which user makes the modification in the web workbook.
