Forum Discussion

Copper Contributor

Mar 17, 2022

Online editing

I've created a worksheet that show data from a table using data validation and sort/filter. It was to be used by several colleagues one but when ever one is using it the information change for all. I...

excel

Excel for web

NikolinoDE

Platinum Contributor

Mar 18, 2022

Conspicuus

Here some informations for Excel for web.

Sheet Views in Excel

Have you ever collaborated with someone else in a worksheet, looking at a large data set, and suddenly the table shrinks and you’re unable to finish your work? It's pretty disruptive isn't it?

Additional info for 365 Abo:

What happened to shared workbooks?

Hope I was able to help you with this info.

Thank you for your understanding and patience

NikolinoDE

I know I don't know anything (Socrates)

Conspicuus
Copper Contributor
Mar 18, 2022
Hey NikolinoDE

Thanks for your suggestions.
I tried both solution. The sheet view was only related to the structure, not editing and the other would not work unless i converted all tables to range which was greyed out. The funny thing is that while I tested the sheet and had others test it as well the problem was not there so I have a feeling this is an upgrade from Microsoft (could be wrong)

Best regards
Kim
- NikolinoDE
  Platinum Contributor
  Mar 18, 2022
  Thanks for the feedback
  
  I am glad that your problem no longer exists.
  It's a shame that it can't be tracked, but as Murphy's Law said...what works, works! :))
  
  I wish you continued success with Excel.
  - Conspicuus
    Copper Contributor
    Mar 18, 2022
    NikolinoDE
    
    I must have written it wrong. None of the solutions worked 😞