We have a relatively large spreadsheet. At ant time there may be up to 4 people updating parts of it. It contains no formulas, but they do use the freeze frame function and some use the filtering tool. Many issues, freezing, lost data, error messages. It has been re built two or three times so far with resulting lost data that had to be re input. Database is not an option.
I don't know how to fix this and am very frustrated.
What are the best practices so this can work? Will it work? Is this a common problem with this feature?
Any comments and suggestions are welcome.
I don't know how to fix this and am very frustrated.
What are the best practices so this can work? Will it work? Is this a common problem with this feature?
Any comments and suggestions are welcome.