Forum Discussion
RareTradesAuz
Dec 11, 2024Copper Contributor
Microsoft Excel linked live organization sheet stopped updating....
I've been using my organizations worksheets with another worker for about 2 years.
all has been well and worked fine until now. the workbook is large with about 1300000 lines of data on the master sheet and about another 15 tabs within the workbook. we did have another sheet linked to the master that the master would pull data from.
i broke the link to see if that would fix the issue and it does not.
we can see each other on the same sheet within the same workbook from different pc's but i can no longer see any changes he makes nor can he see any changes I make
we can be on the same sheet and he will see completely different data to me, we can go to the same cell and i can see his ghost box with hiss account name, and i can watch him move around but he can type something in and it will not update my version.
this sheet runs my business PLEASE HELP ! PLEASE
- RareTradesAuzCopper Contributor
Was a typo, was 130,000 lines on master sheet with more tabs.
i ended up making a copy of the workbook and then running a script to see all the differences, then had to manually change said differences to a new version and then reshared with the coworkers, i still have no idea why it did what it did. but am back up and running for now
- arnel_gpSteel Contributor
1 sheet can only hold 1.04Million lines.
- JKPieterseSilver Contributor
What is the size of your file?
I wonder, do you have a typo in there? Excel cannot hold more than (about) 1 million rows on one worksheet.