Share via

Today formula returns error #REF!

Anonymous
2024-05-23T09:31:34+00:00

hello folks,

When I type formula =TODAY() it returns error: #REF!

Calculation option is set by default to Automatic.

The formula does not work only in one specific Excel file. When I open another workbook, it works.

I created the file on my laptop but it contains several Power queries. Could this be a problem? I can not find any other root cause.

Any ideas please?

Excel version:

Microsoft® Excel® for Microsoft 365 MSO (Version 2404 Build 16.0.17531.20152) 64-bit

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

Answer accepted by question author

Rory Archibald 18,965 Reputation points Volunteer Moderator
2024-05-24T09:23:52+00:00

You have a table called Today (on the Today sheet). Rename it to something else and the function will work.

Was this answer helpful?

3 people found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-05-24T11:22:35+00:00

    it works. Thank you very much!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-05-24T09:15:38+00:00

    here we go:

    https://docs.google.com/spreadsheets/d/1eBJohqWmKYDvv1oVL27I2XZlWkQKppq1/edit?usp=sharing&ouid=112789502627116573426&rtpof=true&sd=true

    The file contains few queries which refer to another excel files in same folder.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-05-23T15:31:08+00:00

    Could you share a test file to reproduce your issue?

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

    Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

    Was this answer helpful?

    0 comments