Leading the way in Microsoft Office Development

Knowledge Base Articles - 2007

214250 - 2007: Cannot Open Multiplan Files

213650 - 2007: Error Opening File That Refers to Shortcut

291295 - 2007: Macro Code to Check Whether a File Is Already Open

213513 - 2007: Prompt to Save Changed Workbook Fails to Appear

289840 - 2007: Registry Keys That Control the File Repair Feature

272025 - 2007: Workbook Appears in Multiple Windows When Opened

Knowledge Base Articles - 2003

555263 - 2003: Macro in Excel Stops After A Workbook.Open Command

324491 - 2003: You receive a 'The file may have been changed' error message when you save a workbook to a network server in Excel 2002 or in Excel 2003

Knowledge Base Articles - 2002

282406 - 2002: 'Print Cell Errors As' Setting Is Lost When You Open and Save Workbook in Earlier Version

274500 - 2002: 'Save Changes in ' Prompt Even If No Changes Are Made

812384 - 2002: 'Unable to read file' error message when you open a workbook in Excel 2002

822380 - 2002: Excel Abruptly Quits When You Save a Workbook

287105 - 2002: Excel Opens Workbook in Repair Mode When Workbook Contains Macros

827270 - 2002: Excel Quits Unexpectedly with an Error Message When You Close an Excel Workbook That Contains DDE Links

179824 - 2002: Features and Formatting Lost Saving to Excel 5.0/95

282155 - 2002: Unable to Insert Workbook If Open in More Than One Window

292500 - 2002: Unable to Quit Excel When the Program Is Running in Reduced Functionality Mode

328196 - 2002: Workbook Unexpectedly Closes Immediately After You Open It

327365 - 2002: Workbook is slow to open in Excel 2002

Knowledge Base Articles - 2000

211444 - 2000: 'Cannot Convert' Error Saving File in Earlier Format

248178 - 2000: 'Cant Open This Item' Error Opening Files from Public Folder

214334 - 2000: 'Check the Spelling of the File' Error Message When You Open File with a Name That Contains Unicode Characters

211838 - 2000: 'Compile Error: Ambiguous Name Detected' If a Module Contains Duplicate Subroutine Names

269679 - 2000: 'Do You Want to Save the Changes You Made to { ?' in French Excel 2000

235333 - 2000: 'File Format Is Not Valid' Error Message When You Open Quattro Pro WB2 or WB3 File

213983 - 2000: 'Filename Is Not Valid' Error Message Saving or Opening File

174658 - 2000: 'Merge Handler' Error Message Dragging Files into Briefcase

248180 - 2000: 'Out of Virtual Memory' message may occur when you open and close many workbooks with controls in Excel 2000

223976 - 2000: 'The Disk Is Full' Error Copying Very Large Worksheet

248176 - 2000: Access Violation Error Message When You Open a Workbook That Calls a Custom DLL

212005 - 2000: Add To List Button Is Dimmed in the Find Dialog Box

211545 - 2000: Always Create Backup Fails on Internet FTP Location

231117 - 2000: AutoSave Settings Are Not Retained Between Sessions of Excel 2000

211818 - 2000: Cannot Edit Automation Objects in Microsoft Excel Viewer

213976 - 2000: Cannot Open Quattro Pro for Windows File in Excel

213547 - 2000: Cannot Programmatically Close Referenced Workbook

211645 - 2000: Changes Not Saved When Workbook Is Opened in Microsoft Outlook

211594 - 2000: Characters Replaced by Question Marks When You Save to Excel 5.0/95 File Format

249076 - 2000: Crash When Closing Excel After Closing Workbook with Circular References

214006 - 2000: Error Message When You Open a Lotus 1-2-3 WK4 File

211380 - 2000: Error Message: &H00000001 Is an Invalid Key. The File Can Not Be Loaded

223808 - 2000: Error Message: Cannot Access Read-Only Document

214088 - 2000: Error Message: Cannot Open Consolidation Source File

223810 - 2000: Error Message: Document Is Not Completely Saved

223812 - 2000: Error Message: Document Not Saved

223813 - 2000: Error Message: Document Not Saved. Any Previously Saved Copy Has Been Deleted.

224134 - 2000: Error Message: File Format Is Not Valid

211596 - 2000: Error Message: Invalid Data Format

234685 - 2000: Error Message: Save Not Completed. File Rename Failed. Retry?

223816 - 2000: Error Message: The Disk Is Full

214342 - 2000: Error Message: Unable to Save External Link Values

271595 - 2000: Error Using Macro to Open or Activate a Workbook

214274 - 2000: Errors Saving File to Earlier Formats

248167 - 2000: Excel 2000 may cause an invalid page fault in MSO9.DLL when you save a file

214131 - 2000: Excel Fields May Save Incorrectly in dBASE Formats (.*dbf)

213606 - 2000: Excel Hangs When You Programmatically Save a Workbook

221052 - 2000: Excel Stops Responding When You Attempt to Open an Excel 4.0 Workbook

214064 - 2000: Fields Truncated When File Is Saved in .dbf Format

211888 - 2000: File Size Increases After Launching Visual Basic Editor

213299 - 2000: For Each Loop to Determine If an Excel Workbook Is Open

213806 - 2000: How to Close All Workbooks But One with a Visual Basic Macro

213635 - 2000: How to Create a Macro That Opens Multiple Selected Files

213456 - 2000: How to Remove the Control Menu and Program Window Controls

213245 - 2000: How to Use a Visual Basic Macro to Open and Retrieve a File on the Internet

248170 - 2000: Incorrect Recommended Format Displayed When You Save Your Workbook

248161 - 2000: Invalid Page Fault Error Opening Workbook with Embedded Enhanced Metafile

215933 - 2000: Invalid Page Fault in VBACV10.DLL Opening French Workbook

104310 - 2000: MS Excel 2.x/3.x/4.x Worksheets Take a Long Time to Open/Save

213383 - 2000: Macro Code to Check Whether a File Is Already Open

213647 - 2000: Macro to Open All Linked Workbooks

213758 - 2000: Macro to Open the Most Recently Used File

166880 - 2000: Most Recently Used List Is Not Updated

269521 - 2000: No Error Message Returned to VBA on Failed Save

209308 - 2000: Office Clipboard Displays One Item When You Copy Multiple Items

248201 - 2000: Opening Workbook with More Than 1370 External Links May Crash

247796 - 2000: Programmatically Exporting Text File Truncates Dates

238488 - 2000: Prompted to Save Changes After Setting the Saved Property to True

214393 - 2000: Revision Number and Total Editing Time Boxes Are Empty

199268 - 2000: Run-time Error 1004 When You Save Workbook as Text

266200 - 2000: Separator in Comma Separated Value (CSV) File Is Substituted Without Warning

214039 - 2000: Some Special Characters Are Changed in Imported Files

212149 - 2000: Status Bar Text Is Bold When Using Large Fonts Display Setting

213753 - 2000: Status Bar Text Not Displayed When You Point to Toolbar or Menu Item

211472 - 2000: The Difference Between Excel 'Merge Workbooks' and Lotus 1-2-3 '/File Combine'

214237 - 2000: Using Excel 2000 Files with Earlier Versions of Excel

215205 - 2000: Workbook Name Contains Invalid Characters

214361 - 2000: You receive the error message 'file not found' when you open a workbook that contains automatic links

Knowledge Base Articles - 1997

177857 - 1997: 'Before You Save...' Error When Quitting Program

167077 - 1997: 'Cannot Convert' Error Saving File in Earlier Format

121942 - 1997: 'Document Not Saved' Saving File Created from Template

171463 - 1997: 'Features Not Supported' Error Message Saving Workbook

131464 - 1997: 'Filename Is Not Valid' Error Saving or Opening File

159679 - 1997: 'Illegal Operation' Opening a Non-Microsoft Excel File

168203 - 1997: 'Later Version' Error Message Appears Opening a Workbook

151064 - 1997: 'Microsoft Excel Cannot Access...' Opening Excel File from Web Server

176242 - 1997: Access Violation or Page Fault Closing a Microsoft Excel Worksheet Object

193481 - 1997: Alert for Previous Version Displays Using OnSave Property

216023 - 1997: CSV Format Loses Digits of Long Numbers When Saving Scientific Notation

190248 - 1997: Cannot Open File After Pasting More Than 2000 Characters

109246 - 1997: Cannot Open Microsoft Works 3.0 or 4.0 Files

147272 - 1997: Cannot Open Multiplan Files

134265 - 1997: Cannot Open Quattro Pro for Windows File

216833 - 1997: Cannot Save Workbook After Network Connection Failure or If Cluster Server Resource Group Moved

139665 - 1997: Cant Open Quattro Pro 6.0 Files

116327 - 1997: Cant Trap No or Cancel in 'Replace Existing' Dialog Box

177970 - 1997: Changes Not Saved When Workbook Is Opened in Microsoft Outlook

010111 - 1997: Characters Lost Saving to Excel 5.0/95 File Format

077295 - 1997: Column Delimiters Missing in Spreadsheet Saved as Text

243936 - 1997: Crash Opening Password-Protected File That Contains Defined Name

166761 - 1997: Created Date Is Not Updated When Saving as a New File

046228 - 1997: Data Lost When File Saved in .DBF File Format

159002 - 1997: Deleting Sheet and Closing Workbook Causes Crash

191960 - 1997: Display Becomes Garbled When You Scroll Through Workbook

111088 - 1997: Documents Closed in Restored State Open Maximized

182671 - 1997: Err Msg: Cannot Be Accessed. The File May Be Read-Only...

185009 - 1997: ErrMsg: &H00000001 Is an Invalid Key When Opening a File

171405 - 1997: Error Closing Workbooks That Contain DDE Links

103329 - 1997: Error Message When You Try to Save a File

236080 - 1997: Error Message: ' Cannot Be Accessed...' Saving File to Windows NT Share

114952 - 1997: Error Opening 4.0 Workbook with Unbound File on Network

132976 - 1997: Error Opening File That Refers to Shortcut

171216 - 1997: Error Opening Password-Protected File with Merged Cells

172358 - 1997: Error Opening Workbook That Contains MS Access Table

172638 - 1997: Error Opening Workbook That Contains Very Long Strings

172356 - 1997: Error Opening Workbook That Is Modified By Using DAO

175852 - 1997: Error Saving File That Contains COUNT in WK1 Format

177248 - 1997: Errors Opening Workbook from Windows Explorer

136733 - 1997: Errors Saving File to Earlier Formats

158996 - 1997: Excel Opens Without Displaying Workbook

186055 - 1997: Excel Quits When You Scroll in Workbook on IBM 770 Laptop

157303 - 1997: Extended Characters in Text or Property Inaccurate

068914 - 1997: Fields May Save Incorrectly in dBASE Formats from Excel

104441 - 1997: Fields Truncated When File Is Saved in .dbf Format

158921 - 1997: File Password Lost Moving File to an Exchange Folder

131550 - 1997: File Saved in XL4 from Lotus 1-2-3 Does Not Display Gridlines

162173 - 1997: File Size Increases When You Save the File in 97 Format

242966 - 1997: Files Open Slowly Across Network

131554 - 1997: Formatted Text (.prn) Limited to 240 Characters Per Line

110708 - 1997: Formatting and Charts Not Saved to .WQ1 Format

166173 - 1997: How to Save Files in Other Formats

159669 - 1997: Illegal Operation Saving Workbook

158895 - 1997: Invalid Page Fault After Closing Last Open Workbook

185584 - 1997: Invalid Page Fault Closing WK4 File

192061 - 1997: Invalid Page Fault Opening Workbook Sent in E-mail

160032 - 1997: Invalid Page Fault Saving a Workbook or Add-In

170492 - 1997: Lotus 1-2-3 Version 5.0 File wth Bitmap Hangs MS Excel 97

166467 - 1997: MRU Displays UNC Path to File on Mapped Drive

162313 - 1997: Merge Workbooks Not Same as Lotus 1-2-3 '/File Combine'

142977 - 1997: Microsoft Access Only Valid External Data for Data Map

174139 - 1997: Microsoft Excel 97 Viewer Cannot Open Lotus Files

107545 - 1997: Multiple Sheets Inserted with Autotemplate

136874 - 1997: New Workbooks Open Repeatedly Starting Excel

116340 - 1997: No Macro Function to Access Solver Dialog Box

125898 - 1997: ODBC Examples from NT Help File Using NWind Data Source

241900 - 1997: Opening Lotus 1-2-3 File May Run Macro Without Warning

138422 - 1997: Opening Quattro Pro WB1 File Causes Invalid Page Fault

198935 - 1997: Page Break Button on Main Toolbar Causes Excel to Crash

169976 - 1997: Page Fault After Saving Microsoft Excel 4.0 Worksheet

168362 - 1997: Page Fault Opening Workbook with a Merged Column

123577 - 1997: Problems Linking/Saving Files with Brackets in File Name

173113 - 1997: Prompt to Save Changed Workbook Fails to Appear

268135 - 1997: Quattro Pro 7.0 (.wb3) Converter Available

159361 - 1997: Read-Only Recommended Opening 97 & 5.0/95 File Format

165240 - 1997: Redo Toolbar Button Does Not Repeat Formatting

175863 - 1997: Reference Incorrectly Listed as 'MISSING' in MS Excel 97

198671 - 1997: Run-time Error 1004 When You Save Workbook as Text

169106 - 1997: Some Worksheet Properties not Preserved

135474 - 1997: Starting Microsoft Excel with a Different Working Folder

168142 - 1997: Status Bar Is Bold When Display Setting Is in Large Font

061941 - 1997: Tips for Importing Lotus 1-2-3 Files to Excel

129161 - 1997: Unsaved Filename Shows in Title Bar After 'Disk is Full' Error

115343 - 1997: Visual Basic Macro to Convert Lotus Files to MS Excel

160333 - 1997: Warning Saving Workbook if It Contains a Sound Note

108474 - 1997: Window Options Are Not Saved in Workspace File

167713 - 1997: Workbooks Saved in Earlier Formats May Open Slowly

187479 - 1997: Wrong Folder Displayed in Save As Dialog Box Quitting Excel