Forum Discussion
Microsoft 365 online excel ledger jumbles the page on screen to where it is not legible. Why?
That's not just "jumbled" (again a vague word, but also a word that comes nowhere near describing what happens, if I'm understanding you), That's a total change, bearing no real resemblance to the original, in layout or in language. It has rows and columns. I personally have no experience with Excel online, so maybe some other viewers can take a look and respond to that dimension.
One has to ask why you leave it open overnight, given this experience. Why don't you just close it and save it at the end of the work day. In general, that would be a good practice.
And why keep it in the on-line version? This appears to be for a company that should be able to afford to have a subscription to Microsoft 365 (based on the sizes of some of the transactions) and have the software (and the file) on your computer, maybe with the file saved on OneDrive as part of the subscription.
This distortion does not happen, right, while you're working on it?
I doubt that it has anything to do with the number of years you've got on it, though I don't know how many years you have or how large each month's data is. Do you use all of the months all of the time? Why not "archive" prior years?
In general, also, if this is just a record of accounts receivable, there's little real need to have a separate sheet for each month. That made sense during the days of paper-based ledgers, but doesn't take advantage of Excel's abilities to handle a continuous record of transactions. It could be a continuous database going on for many years, that makes use of Excel's abilities to create a dashboard that shows only the unpaid (regardless of month) or summaries of a year or a quarter. That would take somebody with some solid experience in designing such workbooks (I'm not offering myself for this, as a retiree, happy to help answer questions and offer simple solutions; but not work for hire.)
