Share via

Shared workbook with team - Formula doesn't work when shared

Anonymous
2023-09-15T17:22:04+00:00

I have created an Excel workbook and have shared it with my team via the sharing option prompted within Excel to "Share", When shared, formulas that are in the worksheet do not work but are visible. Why are my formulas not working as they do in my original Excel file?

The formula that doesn't work is the following:

                             =IF(C8<>"",IF(E8<>"",E8,NOW()),"")

In this case, I have the formula in cell E8 to return the date/time stamp when a character is entered in C8. The formula works in my original workbook and returns the time stamp as shown. When opened as a shared document, the formula doesn't calc. until I edit the formula line and hit enter at which time it returns the result below:

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-09-16T07:22:43+00:00

    Could you share us a test workbook with some dummy data in it to reproduce your issue? Then we may give suggestions on it.

    For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments