Showing results for 
Search instead for 
Did you mean: 
New Member

"Excel Files containing formula are currently not supported."



After editing the raw excel sheet for my app I now receive this error when I launch the app:


Failed to load Table13_3. The requested operation is invalid. Server response: Table13_3 failed: Excel files containing formula are currently not supported. Please use a file that has no formula. clientRequestId: 40fd0cda-2178-4dca-a938-82382662596f serviceRequestId: 40fd0cda-2178-4dca-a938-82382662596f


I have tried refreshing data, rebuilding the table as raw data only, and relinking all of the tables. I know it is possible to display this data as it previously worked prior to making updates. Does anyone know how to get around this?


Thank you!

Community Champion
Community Champion

Re: "Excel Files containing formula are currently not supported."

You can move the Data to another table and ensure that there are no calculations in the excel Table. Connect and that should work


The issue is no calculations in the excel Table


If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.


Re: "Excel Files containing formula are currently not supported."


Could you please share more about your scenario, do you have calculated columns within your excel sheet?

Actually, there is no workaround to use excel file containing formula in PowerApps right now.
However, there is already an idea that you can vote for Using Excel files with formulas as a data source

As an alternative workaround, you could convert all required excel formula as a PowerApps formula when you add a new item in PowerApps.

If there does not have calculated columns, please try to go to the left-side menu, click on your Excel sheet, then click the Refresh option. Delete the possible affected Column, like Date, Currency, etc and add it back.

What's more, it can be a "caching" issue, you can try to cache

Best Regards,



Helpful resources

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!


Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.


Super Users Coming in August

We are excited for the next Super User season.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,031)