What is your goal?
Update a table row in Excel
What is the problem & what have you tried?
Usually I always work with Google Sheets, but a client has asked me to work with Excel. And I’ve just realised that there appears to be no update a table row module for Excel. Which is mind-boggling to me. My research uncovered that Excel prefers make modules that edit tables as opposed to worksheets. And so I’ve built my scenario around adding a row to a table, and all of my spreadsheets are tables. But now I’ve gotten to the point of wanting to update a row, and there’s only “Update a worksheet”. You can add a row to a table. And you can do all sorts of other things with tables. But you cannot update a table row. This is ridiculous. And I see people commenting on forums here saying, “Use update to worksheet row.” No, this does not work. Because the row reference is incorrect, it always updates the row above the row you actually want to update, because it’s not taking into account the header row. The only workaround that I’ve found for this seems to be to use Microsoft Graph. But this seems like a real clunky workaround. Does anyone know of any other way to do what should be a very simple thing.
Why are you using table instead of worksheet though? Cause there is both add and update worksheet row.
Hey, thanks. So it’s not just me then. Good to know. Yeah, I couldn’t remember the exact reason why tables were better to use, but I guess I don’t quite understand the reason why. What would be the problems I would encounter if I just started using worksheets instead? I mean, one that I do know of is those kinds of self-filling formulas, where every time a new row is added, the formula from the row above gets replicated into the next cell down in the new row. Which I believe is a feature of tables, and it’s definitely something I cannot lose.
And how does this AI generated response answer the question? Did you at least read it before copy pasting it mate?
Oh right yeah. Well one way would be to hardcode the formulas in the module when doing a worksheet so they will be added every time the module runs.
But for using tables you will need to use Make an API call module to update a specific row.
ooooh snap! Hardcode the formulas. That’s a great idea. Why didn’t I think of that? I love it. OK. so that would be potentially, there better workflow for my situation then. I don’t use tables. I use worksheets only. You sound pretty knowledgeable and have some great ideas. So can you tell me the reason why I would want to use worksheets other than this situation here? When working with spreadsheet-type data in Make (Excel). In the research I did it just told me that that tables were more reliable. But I’l be honest, I just allowed the AI to guide me here, it was not something I felt like going into a lot of detail to figure out (and yes, I am cognizant of the fact that it seems to have come round to bite me in the end, but you gotta choose your battles! I’m still learing here).