ExceLINX: Why does ExceLINX periodically freeze up if Excel's AutoSave add-in is enabled?
Software: ExceLINX-1A, ExceLINX for PicoAmmeters/Electrometers
Integra Series: 2700, 2701, 2750
Low-Current/High-Resistance Meters: 6485, 6487, 6514
Question : Why is the error â€œNo Return() or Halt() function found on macro sheetâ€ generated? Why does ExceLINX appear to periodically freeze up with the AutoSave add-in enabled?
Answer: The â€œNo Return() or Halt() function found on macro sheetâ€ generally arises because of a conflict between Add-Ins. The Microsoft Excel 2000 version SR-1 had a particular problem with the AutoSave Add-In. This problem was corrected with version SR-3 of Microsoft Excel. Please refer to Microsoft Knowledge Base Article # 316399 for more information.
However, regardless of the version of Excel, ExceLINX may continue to conflict with the AutoSave Add-in particularly when communicating with the instrument over the RS-232 interface. The periodic backups that the AutoSave add-in prompts may interrupt the communication between ExceLINX and the instrument. An interruption in data retrieval may cause ExceLINX to freeze or hang up.
Should you like to maintain a backup of the data, you may consider using the â€œLog Fileâ€ feature of ExceLINX. Logging to file simultaneously copies the data to a text file while loading it to an Excel spreadsheet. To Log to File, select the file to which you would like to save the data. Before running the DMM Scan sheet, press the â€œRecordâ€ button and then start the scan.
This FAQ Applies to:
Product Series: Keithley 2700 Multimeter/Data Acquisition/Switch Systems
FAQ ID 70151View all FAQs »