I've downloaded a file, NPPES Data Dissemination, off the web. It's zipped, approx 400 mg. I use WinZip to unliz, end up with a CSV file, 4.15 gig in size. I've tried opening it in Excel 2010 - any nbr of ways:
1. By double clicking on file itself.
2. Open Excel in the safe mode, then opening file.
3. Start Excel first, then select open the file Excel.
4. Turned off all services, then retried nbr 1 thru 3.
5. Used Gsplit to split the file up into 5 pieces, approx 1 gig each.
No matter what I try invariably I end up with this msg - Excel Cannot Complete This Task With Available Resources. I click ok, it opens it but no ribbon, just data grid.
I'm using Windows 7 Pro, Office 2010, WinZip Pro, V15, on a Dell Studio Desktop, 8 gigs of memory, 1000 gig hard drive, approx 850 gig free.
Can someone help or advise? BTW you can download the file, just google NPPES Data Dissemination.
Bookmarks