question

bob247-0478 avatar image
0 Votes"
bob247-0478 asked emizhang-msft commented

Excel query doesn't work on different computer

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.

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emizhang-msft avatar image
0 Votes"
emizhang-msft answered emizhang-msft commented

Hi @bob247-0478,
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.






309.png (30.7 KiB)
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


Hello @emizhang-msft

We are running the latest version of office 365, and the same bit version of excel.

0 Votes 0 ·

Did the query need to permission to create the connection?

0 Votes 0 ·

yes, we need to use permission

0 Votes 0 ·
Show more comments