Quote:
|
Originally Posted by OZDOC
??? the new version of excel has over 1 million rows ( may be wrong ) but even the current sytem can handle Large data, but i may be wrong again
incorrect i have many large files that do not break down
i do / have and no problems
If you think I am wrong and want proof, just google "Excel corrupt" and "Excel crash" and see the hundreds of postings and "tools" available to try and reclaim data.
i dont wish to go down the your wrong i am right path but just to so it has proven stable when set up right for me
this is an option that can be turned of and excel has had auto save for some time
as above new version 1 million
??? not sure why it happened to you
but stating that excel is open to coruption is not from my experiance true and i push it to every boundry known.
|
Ozdoc,
I am stating from my experience too.
Isn't it better to advise people on what's gone wrong than what hasn't?
The new version does not have one million rows and Excel never will have one million rows, the file system cannot handle it.
65,536 rows is in the new Beta version which I have also road tested last month, being a Microsoft software agent.
You have been lucky.
You have gone down that path, by stating that I am wrong, and I supplied proof of what is inevitable.
Yes, you can turn off autosave, that wasn't the statement, the statement was the reason it is there built in in the first place.
I know why it happened to me, because when I lost my data, I contacted Microsoft who responded:
"Dear Sir,
Microsoft Excel is part of the Microsft Office package.
Within that package is a flat file Excel spreadsheet program, and Access a relational database.
While we have addressed many issues with Excel crashing through the release of Service Packs, the Excel package was never designed to hold large amounts of data. Large amounts of data should be stored within the Access program and for reporting purposes exported to the Excel program for reports, summaries, graphs etc.
It is recommended that large amounts of data not be stored in Excel as the file system is not as advanced as Access in coping with large numbers of records.
Regards,
Microsoft Office Support"
I am correct in my statements, just because it hasn't happened to you, doesn't mean it won't or can't happen to someone else.
My advice was offered as help and to be cautious. I don't want to be responsible for someone losing a year's work.
Just last week I was called into an organization, which lost all it's yearly cashflow projections due to file corruption.