Share via

Excel query doesn't work on different computer

bob247 1 Reputation point
2021-04-01T14:55:17.72+00:00

Hello,

I created an excel workbook that has a query. I can run it from my computer just fine. Another colleague can run it from their computer just fine, but a different colleague can't. It gives them an error: [Expression.Error] The column 'TIME_SPENT
I tried deleting the transformation, but then the next one also gave the same error, just for a different column.

Not sure why this is happening.

Thanks for the help.

Microsoft 365 and Office | Excel | For business | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 30,191 Reputation points Microsoft External Staff
    2021-04-02T07:48:35.967+00:00

    Hi @bob247 ,
    Did all users have the same version of Excel? Did you use 32-bit or 64-bit version of Excel?

    I suggest you check if the problem computer have the same version of Excel, you can go to File- Account and check the version information:
    83973-309.png

    And also make sure the problem computer using the same bit version of Excel.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

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.