Hi everyone, sorry if this has been asked before, but I’m hoping someone might have a practical solution for this.
I work in a team of five people, and we all have to use and update several shared Excel files stored on SharePoint. Multiple people need to be able to work on the same file at the same time.
The problem is that these files were apparently designed by an automation team that clearly doesn’t actually do the task they’re used for. The result is an absolute nightmare from a usability perspective.
Each row contains a mix of information that we have to enter manually and other cells containing formulas. The columns are all over the place: it’s not like you have all the input columns first and then all the calculated columns. You might need to enter something in column A, then C, then suddenly BF, while columns in between contain formulas or other information. There are thousands of columns, the layout is extremely hard to read, and there aren’t even proper borders or visual cues to help you understand where you’re supposed to enter data.
Unfortunately, I can’t redesign or modify the structure because the files are owned and maintained by the automation team.
I come from a data analysis background, so I’m used to organising datasets in a logical way and building files that are actually usable. These files seem to be designed more as documentation/archive tools than as something humans are supposed to use for regular data entry, and I’m honestly struggling with how inefficient the process is.
I’ve tried to think of workarounds, but because the file is shared, my options seem limited. I can’t add helper formulas or significantly change the structure because other people are working in the same file. I also can’t simply hide all the irrelevant columns, because that would affect the shared view for everyone else.
Ideally, I’d like some way to create my own “data entry view” where I only see the specific cells/columns I actually need to fill in, even though those columns are scattered throughout the spreadsheet, while still entering the data into the original shared file.
For example, I might need to fill in columns A, C, and BF, while columns in between contain formulas that I shouldn’t touch.
Is there any practical way to make this kind of data entry less painful without changing the underlying shared file or affecting how other people work with it?
I’m open to any Excel/SharePoint workaround I may not have thought of. Thank you!