Reporting status of external references in a spreadsheet without updating

• US 6,898,760 B2
• Filed: 01/05/2001
• Issued: 05/24/2005
• Est. Priority Date: 01/05/2001
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Natarajan, Ramakrishnan, Rader, Marcella C., Gauthier, Matthew C., Maguire, Justin M. III, Huynh, Tuan E., Bedford, Jesse Raymond
• Primary Examiner(s): Hong, Stephen S.
• Assistant Examiner(s): Hutton, Doug
• Application Number:
  US09/755,414
• Publication Number:
  US 20020091730A1
• Time in Patent Office: 1,600 Days
• Field of Search: 715/503, 715/501.1, 715/507, 707/1, 707/10
• US Class Current: 715/205
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

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.

Claims

1. A computer-implemented method for reporting the status of a link in a spreadsheet application program module, the link referring to a source, the method comprising the steps of:

receiving an indication to check the status of the link;

initiating a procedure to check the status of the link including a prompt to check the status of the link;

determining the status of the link by verifying that the source exists including analyzing the source to identify specific information associated with the source before updating the link; and

displaying the status of the link utilizing information identified in the determining step.

2. The method of claim 1 wherein the step of receiving an indication to check the status of the link comprises receiving an indication that a Check Status button has been selected.

3. The method of claim 2 wherein the Check Status button is located in an Edit Links dialog box.

4. The method of claim 3 wherein the Edit Links dialog box further comprises a source column and a status column associated with the link.

5. The method of claim 4 wherein an indication of a source file associated with the link is displayed under the source column and an indication of the status of the link is displayed under the status column.

6. The method of claim 1 wherein the step of determining the status of the link comprises determining whether the source associated with the link is valid.

7. A method for determining the status of a link in a client workbook of a spreadsheet application program module, wherein the link is associated with a source file, the method comprising the steps of:

initiating a procedure to check the status of the link including prompting a user to check the status of a link;

determining the status of the link by examining whether the source file exists and is in a proper format including rarely encountered link problems before updating the link; and

,

displaying a textual indication of the status of the link.

8. The method of claim 7 wherein the step of determining the status of the link comprises the following steps:

determining whether the source file resides on a web server;

if so, then copying the source file to a temporary local file; and

if the source file can not be successfully copied to a temporary local file, then reporting an error as the status of the link.

9. The method of claim 8 wherein the error is displayed as “

Error;

source not found”

.

10. The method of claim 7 wherein the step of determining the status of the link comprises the following steps:

determining whether the source file is open;

if so, then reporting an indication in the status of the link indicating that the source file is open.

11. The method of claim 10 wherein the indication is displayed as “

Source is open”

.

12. The method of claim 7 wherein the step of determining the status of the link comprises the following steps:

determining whether the source file resides in its specified location;

if not, then reporting an error as the status of the link.

13. The method of claim 12 wherein the error is displayed as “

Error;

source not found”

.

14. The method of claim 7 wherein the step of determining the status of the link comprises the following steps:

determining whether the source file can be opened;

if not, then reporting an error as the status of the link.

15. The method of claim 14 wherein the error is displayed as “

Warning;

Status indeterminate”

.

16. The method of claim 7 wherein the step of determining the status of the link comprises the following steps:

determining whether the source file is valid;

if not, then reporting an error as the status of the link.

17. The method of claim 16 wherein the error is displayed as “

Warning;

Status indeterminate”

.

18. The method of claim 7 wherein the step of determining the status of the link comprises the following steps:

determining whether the link may be updated without fully loading the source file;

if not, then reporting an error as the status of the link.

19. The method of claim 18 wherein the error is displayed as “

Warning;

Open source to update values”

.

20. The method of claim 7 wherein the step of determining the status of the link comprises the following steps:

determining whether there is at least one worksheet in the source file;

if not, then reporting an error as the status of the link.

21. The method of claim 20 wherein the error is displayed as “

Warning;

Status indeterminate”

.

22. The method of claim 7 wherein the step of determining the status of the link comprises the following steps:

determining whether the source file was last saved without being fully calculated;

if so, then reporting an error as the status of the link.

23. The method of claim 22 wherein the error is displayed as “

Warning;

Source not recalculated”

.

24. The method of claim 7 wherein the step of determining the status of the link comprises the following steps:

determining whether a worksheet referenced by the link is in the source file;

if not, then reporting an error as the status of the link.

25. The method of claim 24 wherein the error is displayed as “

Error;

worksheet not found”

.

26. The method of claim 7 wherein the step of determining the status of the link comprises the following steps:

determining whether names referenced by the link are in the source file;

if not, then reporting an error as the status of the link.

27. The method of claim 26 wherein the error is displayed as “

Error;

undefined or non-rectangular name”

.

28. The method of claim 7 wherein the step of determining the status of the link comprises the following steps:

determining whether the values in the source file are copied from a temporary source;

if so, then reporting an error as the status of the link.

29. The method of claim 28 wherein the error is displayed as “

Values updated from temporary source”

.

30. The method of claim 7 wherein the step of determining the status of the link comprises the following steps:

determining whether the link has been updated since the file was loaded into RAM;

if not, then reporting an error as the status of the link.

31. The method of claim 30 wherein the error is displayed as “

Warning;

values not updated”

.

32. A computer-implemented method for reporting the status of a link in a spreadsheet application, the link referring to a source, the method comprising the steps of:

receiving a prompt to check the status of the link;

initiating a procedure to check the status of the link;

determining the status of the link by checking whether the source exists and has a proper format before updating the link; and

displaying the status of the link.