Monday, May 19, 2008

Registry Edit to Let Excel 2003 Read Quattro Files

After much screwing around with the Microsoft advice and reading of other postings, here are the contents of the REG file I created that now allows me to read old Quattro and Lotus (e.g., WKS, WK1, WQ1) files with Excel 2003, after getting an error message reading, "You are attempting to open a file that is blocked by your registry policy setting":

Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security\FileOpenBlock] "LotusandQuattroFiles"=dword:00000000 "LegacyBinaryFiles"=dword:00000000 "LegacyDatabaseAndDatasourceFiles"=dword:00000000 [HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Security\FileSaveBlock] "LotusandQuattroFiles"=dword:00000000 "LegacyBinaryFiles"=dword:00000000 "LegacyDatabaseAndDatasourceFiles"=dword:00000000
Note: in case it wraps oddly in your browser, each opening quotation mark begins a new line, as does each opening bracket. You also need the title line. To make it work, copy and paste those lines verbatim into a Notepad file. Save it in Unicode formatting to a file called "Enable Excel to Read Quattro Files.reg". Close it. Double-click on it and run it. Same basic instructions for another REG file I have here, which I have named "Enable Excel to Open Old Spreadsheets.reg". I didn't have to run it today, but I believe the updating of Office 2003 with Service Pack 3 (?) did require it previously:
Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common\OICEExemptions] "ExemptDirectory"="E:\\Current\\Projects\\Computer and Data\\Old Data\\Old Spreadsheets"



Let's try that again. On my screen, at least, the long lines in the REG files are obscured. It goes like this:

For the first one:




For the second one: