This alerts you if the linked data type cell could not be refreshed. Using the Excel Options dialog box igure . If a cell formatted as a date is pointing to cells formatted as a number, the Misleading Number Format warning displays. 8. Default PivotTable Layout is found in the new Data...
In theSave Asdialog box, select “Excel-Macro Enabled Workbook (*.xlsm)” and clickSave. When you see the popup message “Be careful! Parts of your document may include personal information that can’t be removed by the Document Inspector“, clickOK. Close all of your opened windows. Open...
"Be careful! Parts of your document may include personal information that can't be removed by the Document Inspector."Here's a screen shot of the error message -- I put the text onto 2 lines, so it's easier to read.If you click OK in that warning message, another message appears: ...