How to Update Only Specific Cells in an Excel Table Without Affecting Formulas?

(1) Share

Report

Posted on by LL-31011129-0

Hi everyone,

I have an Excel table that is part of a larger model with dynamic formulas that update daily. When I receive an email with an attachment or retrieve data from a server, I want to update only specific cells in the table (highlighted in blue) while keeping the rest of the table untouched.

What I need to achieve:

1️⃣ Clear only the content of the cells that are highlighted in blue, without deleting the rows or affecting other columns.
2️⃣ Insert new data into these cleared cells from an external file.
3️⃣ Export 3 specific columns from the updated table at the end.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

From cloud you can call a desktop flow and run attended or unattended. You will be calling a Power Automate for Desktop flow and there are specific actions that can do the tasks you are looking for.

The first action can clear the values in a specific range without effecting other formulas or values.

The second, can write a value to a specific cell. You can also write to named cells. You will most likely need to have a loop here and write to each cell (pretty easy to do btw).

The last action, can read the values in the 3 desired columns you want and store the values in a variable, then do something with them later, such as emailing them, etc.

Here's a short list of Excel actions in Power Automate for Desktop.

------------------------------------------------

⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
LL-31011129-0 2 on at

Like (0)

Report

Great overview and thank you for the reply. I currently does not have the License to use Desktop. Is there a way to use the online version?
This is as far as i've come.

I've saved the file from email to my Folder. After that i'm stuck..

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hey there!

I am following up on this post how to update only specific cells in an excel table without affecting formulas? in this category building flows from 02/03/2025. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 2 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No