Microsoft Technology Licensing, LLC

Jesse Raymond Bedford

Justin Michael Maguire

Tuan Huynh

Matthew Charles Gauthier

Ramakrishnan NataraJan

Marcella C S Rader

Jason Matthew Cahill

Andrew James Becker

Jason P Allen

Timothy F Ahlers

Marcella Rader

Aleksandr Slepak

The invention, in one embodiment, is a method and system for reporting the status of external references, or links, of a spreadsheet workbook. In an Edit Links dialog box, the user may view a list of links and their status. The user may select a Check Status button in the Edit Links dialog box to check the status of the links without updating the links because updating the links may require considerable time. A textual status message is displayed for each link in the Edit Links dialog box. The textual status message indicates to the user whether there is s possible problem with the link. As part of checking the status of a link, an analysis is made to determine whether any problems with the source file exist. For instance, it is determined whether the source file is open and whether it is valid. The results of this analysis determine what is displayed in the status column of the Edit Links dialog box.

Reporting status of external references in a spreadsheet without updating

A method, system, and apparatus for providing access to asynchronous data in a spreadsheet application program is provided. When a request is received to utilize an asynchronous data element in a spreadsheet, the spreadsheet application program instructs an asynchronous data server to provide updated values for the asynchronous data element. When the asynchronous data server program receives an updated value, it notifies the spreadsheet application program that a changed value for the data element is available. The next time the spreadsheet application program has idle processing time following a notification that an update is available, the spreadsheet application program determines whether a notification has been received from the asynchronous data server program. If an update is available, the spreadsheet application program contacts the asynchronous data server and requests the update. In response, the asynchronous data server program transmits the update to the spreadsheet application program.

Method, system, and apparatus for providing access to asynchronous data in a spreadsheet application program

Growing community of inventors

Renton, WA, United States of America

Jesse Raymond Bedford