09-15-2020 05:19 PM - last edited on 09-16-2020 05:34 AM by Allen
09-16-2020 05:40 AM
First thing: You need to remove this file as soon as possible...it includes a lot of personal info on your customers and I'm sure none of them would appreciate that.
Second: without looking too extensively at what you have, it appears that there's a fair amount of redundancy of data, which suggests that a total re-design might serve to reduce the size of the file. A good database design would eliminate all (or most) of the redundancy. This has the look of something that began when the company was small and now has grown and grown--good for the business--but this inventory and order tracking system is reaching (or has reached) its limits. Do you have anybody who knows databases who could really re-design this for you? Can you hire somebody locally?
An alternative: you might be well advised to look for a good dedicated inventory management system.
Another alternative: convert this from Excel to Access--which is Microsoft's database system.
Truly, though, it looks to me as if you need to get somebody and pay them to do a total overhaul.
09-16-2020 07:22 AM
Many thanks for pointing this out - I cannot seem to find how to remove the file and now freaking out, it was beyond stupid of me to upload this file.
Yes, I will indeed look into redesigning this particular file but overall I am looking at options we can use to collaborate live on an excel sheet with the full extent of Excel's features. So while a redesign would sold the problem regarding this particular file it won't solve the overall issue.
I'd love to get Microsoft to allow us working on files larger than 5mb, we'd be willing to pay for it if there was a package without this restriction of file size...
09-16-2020 07:25 AM
@Sergei Baklan if we open from One Drive and edit on desktop Excel we cannot see each other's changes/contributions live - that would be the most important part for me to be able to work on this just the same as we would on Google sheets - but we do need the full extent of the Excel features such as editing formulas that draw data from separate tabs which we cannot do on Sheets...
09-16-2020 07:36 AM
That is strange, Excel Desktop and Excel Online work in co-authoring mode by exactly the same way. Please check here in FAQ Collaborate on Excel workbooks at the same time with co-authoring if you don't meet some requirements for that. As variant co-authoring could be switched-off in settings of your desktop applications.
09-16-2020 08:57 AM
The file was removed, at my request, by the system moderator. They did it, in this case, faster than I've ever seen it done before. Had they not done so, you would have been able to do it by entering the Edit mode on your original post and then delete the attachment.
As a general rule, though, the website prohibits the posting of any spreadsheets that contain proprietary or personal information.....and that especially applies to lists of customers, patients, etc. It's an easy mistake to make the first time, but make that your learning experience.