I have handled excel file size of around 2GB. I used to work at a start-up then. So, we relied on excel only during initial days.
I always keep a backup of the original file :) There are several checks you can make in excel file to make it faster, for example, disable automatic calculation once you apple formula. This way, when you edit anything, the sheet will only refresh once you hit f9. Similarly, I don't use vlookups in large sheet.. So, many optimizations are there. And of course, your laptop should be powerful enough to handle the file. But I agree there is a limitation to the file size, that's why we purchased Tableau after a couple of years for data analysis stuffs.
Windows makes backups but are very unreliable, until Win7 it was useless, (I don't know how is nowadays);
Windows has improved, very much actually. Backups work in Windows 8+ , but I don't know about Windows7. Their support groups and forums are very helpful. The admins respond. Overall the support has improved actually.
it comes with a browser whose only mission is to get another browser; a text editor that is worst that any other; a media player, well... useless;
Please try Edge browser once. I found it faster than Firefox. And VS code text editor ( by Microsoft) is Love .... But yes, its media player is a big No for me.
Agree with your point that sometimes Windows updates are uglier, cannot deny with that. But I am sticking with it for the time being because I have been using Windows for years, and my mind is addicted to windows :)
Overall I think, using any OS is based on user's choice and need. I can do web dev on windows but I will have to struggle when it comes to fixing codes. I can work on linux too but being a non-techie, I would have to learn some command lines first. I can do that easily, but I choose Windows because I don't have to learn command line to install a software in Windows. So, it is based on use case and need.
Windows is a boon for the people who come from a non-tech background. They can work on excel, watch movies, browse .. and that too with a few click.. Not by typing ..
Someday, I might uninstall Windows from my laptop once I get comfortable with programming/web dev.
Thank you so much Robert for sharing your experience with us :)
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Hi Robert,
Thank you for your feedback on my post.
I have handled excel file size of around 2GB. I used to work at a start-up then. So, we relied on excel only during initial days.
I always keep a backup of the original file :) There are several checks you can make in excel file to make it faster, for example, disable automatic calculation once you apple formula. This way, when you edit anything, the sheet will only refresh once you hit f9. Similarly, I don't use vlookups in large sheet.. So, many optimizations are there. And of course, your laptop should be powerful enough to handle the file. But I agree there is a limitation to the file size, that's why we purchased Tableau after a couple of years for data analysis stuffs.
Windows has improved, very much actually. Backups work in Windows 8+ , but I don't know about Windows7. Their support groups and forums are very helpful. The admins respond. Overall the support has improved actually.
Please try Edge browser once. I found it faster than Firefox. And VS code text editor ( by Microsoft) is Love .... But yes, its media player is a big No for me.
Agree with your point that sometimes Windows updates are uglier, cannot deny with that. But I am sticking with it for the time being because I have been using Windows for years, and my mind is addicted to windows :)
Overall I think, using any OS is based on user's choice and need. I can do web dev on windows but I will have to struggle when it comes to fixing codes. I can work on linux too but being a non-techie, I would have to learn some command lines first. I can do that easily, but I choose Windows because I don't have to learn command line to install a software in Windows. So, it is based on use case and need.
Windows is a boon for the people who come from a non-tech background. They can work on excel, watch movies, browse .. and that too with a few click.. Not by typing ..
Someday, I might uninstall Windows from my laptop once I get comfortable with programming/web dev.
Thank you so much Robert for sharing your experience with us :)