Key answer
Inventory the file's contents first, then specify objects, ranges and versions. “Look at this Excel file” leaves open the current sheet, all details, filtered records or hidden-sheet parameters.
Full explanation
Microsoft's Document Inspector explains that Office files may contain hidden rows/columns, hidden sheets, comments, revisions and embedded content; hidden-sheet data can affect formulas. Visible content is not necessarily the complete source. Official documentation
Ask for a short inventory of file version, sheet/attachment names, readable ranges, hidden content and external references. Specify:
· All records or only filtered visible ones; whether to exclude totals and duplicates.
· Formulas, currently displayed values or recalculated values; which parameter sheets participate.
· Final document text or tracked changes/comments; whether embedded attachments must be opened.
· Whether external linked materials are in scope and actually accessible.
Count all records in “Sales details,” including filter-hidden rows, excluding the final total row. Interpret currencies using “Parameters”; exclude other sheets from aggregation. First list sheets read, row counts and missing external dependencies, then calculate.
Export formats change scope too. Microsoft's Excel-format guide notes that CSV saves the active sheet's text and values, losing formatting and other features. A CSV upload cannot replace inspection of every sheet and formula in the original workbook. Format guide
The inventory confirms reading and aggregation boundaries. If a tool sees only some sheets or cannot inspect embedded attachments, list missing items and supply the corresponding files.
References
2. Microsoft, Excel formatting and features that are not transferred to other file formats, CSV section