Preserve Formatting on Overwrite Does not work with Named Range in Excel

I am trying to overwrite a named range in Excel but keep the formatting. However when I select Preserve Formatting on Overwrite, the formatting is still removed. I've attached a very simple workflow along with and Excel file with the corresponding named range.

The formatting is preserved if I use the cell number "A1:B3" however, this won't work because in my actual workflow the named ranges could have varying sizes and start at different locations through out the sheet.

Thanks!

Named Range Format.xlsx

Named Range Format.yxmd

Output

Bug

Accepted answers

binu_acs

@tim-regas if you want to make it dynamic then I think the count record tool an option here

Named Range Format.yxmd

All comments

gabrielvilella

You must have the range if you want to preserve formatting. If your range varies, you can insert a value that is long enough to accommodate all your data always or have the range being updated dynamically based on your data. For this last one you will need to build the processes within the workflow to updated the full path.

binu_acs

@tim-regas if you want to make it dynamic then I think the count record tool an option here

Named Range Format.yxmd

tim-regas

@binuacs This is exactly how I will need to make it dynamic. Thank you very much for the example on how to make it dynamic!

DavidP

Hi @tim-regas

Some notes on cell ranges:

If you specify a cell range A1:B6, it is an exact range from column A to B and from row 1 to 6. However, if you know the column range ( A to , but you don't know the row range, you could specify the range as

A1:B

This will write data for the column range A to B, and start writing data at row 1 for as many rows as you have in your dataset. It's an easy way to deal with fixed columns but variable rows and it will preserve any existing formatting if you selected that option.

smburns25

Do we know when this bug will be fixed or if it has been in a current version. This is obviously a flaw that should be addressed and not a work around to be documented.

I just ran into this and the only solution I have, as this is a production report, is to have it overwrite the file and not preserve formatting.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703