Hi,
My excel says that I have linked workbooks and asks me to update them (the 'Inquire' addiin workbook relationship also lists 4 related workbooks) . I cannot find out how they are related and hence cannot remove them from being linked.
Please help and note I have already tried the following to identify the link but to no avail:
1) I deleted all worksheets in my workbook so now i have only one blank 'Sheet 1'.. still not solved
2) I deleted all things listed in Name Manager...still not solved
3) Nothing in conditional formatting/data validation...still not solved
4) Charts /shapes...everything deleted so none....still not solved
How can it still be showing as linked? where are these links and how to remove? Please see output of Inquire workbook analysis showing 6 linked workbooks with nothing else there:
Summary
lease see output of Inquire workbook analysis showing 6 linked workbooks where as I have removed everything:
Summary
Item Value Reviewer Comments
Creation Date 11 February 2019 15:08:51
Modified Date 07 March 2019 15:46:10
File Size (bytes) 26,438
Title
Author NA
Linked Workbooks 6
DDE Links 0
Data Connections 0
Visible Sheets 1
Hidden Sheets 0
Very Hidden Sheets 0
Formulas 0
Array Formulas 0
Formulas With Errors 0
Formulas With Logical Values 0
Formulas With Numeric Values 0
Formulas With Date/Time Values 0
Formulas With Textual Values 0
Formulas With Numeric Constants 0
Formulas With Textual Constants 0
Formulas With Nested IF Statements 0
Formulas Without Cell References 0
Formulas Referencing Blank Cells 0
Formulas Referencing Hidden Cells 0
Formulas Referencing Text Cells 0
Formulas Referencing External Workbooks 0
Formulas Formatted As Text 0
Positive Formulas 0
Negative Formulas 0
Unique Formulas 0
Duplicate Formulas 0
Inconsistent Formulas 0
Cells With Dependents 0
Cells With Textual Constants 0
Cells With Numeric Constants 0
Cells With Comments 0
Cells With Validation Criteria 0
Cells With Conditional Formatting 0
Cells With Numerics Stored As Text 0
Invisible Cells 0
Used Input Cells 0
Unused Input Cells 0
Occupied Cells 0
Merged Cells 0
Blank Cells 0
Blank Referenced Cells 0
Unlocked Cells 0
Hidden Rows and Columns 0
Named Items 0
Named Items With Errors 0
Warnings 1
Bookmarks