Urgent - Excel Folder Permission is not allowing any files to Write or change data

Thinking about it a little more, you know the number of rows and columns you’re writing, so you know the range you need to format.

I don’t know the range as each time it will be different.

I’ve got the solution.

You know how many rows and columns you’re writing, so you know the range you’re writing.

What is the solution? Post it so others may find it in the future if they have the same question.

I changed the folder permission and saving files locally to update and then moving to appropriate location.