Open the Excel Workbook and Create Formulas for Highlighted Cells
Question details
The user needs eight formulas for highlighted cells in an Excel workbook that could not be opened.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- Create formulas on the 49ers conference and 49ers division worksheets.
- Observed behavior
- The attached workbook could not be opened, so the highlighted cells and their formula requirements could not be inspected.
Locate the original workbook and check its file type and name. Identify the highlighted cells, their worksheet names, and the expected result for each formula.
Reupload the workbook with a shorter file name
Use this approach when the uploaded workbook cannot be opened for review.
In Excel, select File > Open and try opening the original workbook. Confirm that it is a supported Excel file, such as an .xlsx or .xls workbook.
If the workbook opens, select File > Save As and save it with a short name such as 49ers.xlsx. Choose an Excel file type in the Save as type menu rather than changing the extension manually.
Use the attachment or upload button to submit the newly saved workbook. If the original will not open, report that behavior and provide the original file type.
List the highlighted cell addresses on the 49ers conference and 49ers division sheets. For each cell, include the expected result, relevant source ranges, and any values or formulas visible in the reference images.

Provide worksheet details if the file still cannot be opened
Use this option to get formula guidance without relying on the workbook attachment.
Review the Workbook and Enter Formulas in WPS Spreadsheets
Use WPS Spreadsheets to open a supported workbook, inspect the highlighted cells, and enter formulas once their source ranges and expected results are known.
- 1. Open the workbook: In WPS Office, select Open and choose the Excel workbook.
- 2. Inspect the target cells: Select the 49ers conference and 49ers division sheet tabs, then click each highlighted cell to check its address and surrounding data.
- 3. Enter the formulas: Once the calculation requirements are clear, select a target cell and type its formula in the cell or formula bar. Repeat for the remaining cells.
- 4. Check and save: Compare each result with the expected value, then select File > Save As to save the workbook in an Excel-compatible format.

Frequently Asked Questions
Why can't the eight formulas be provided yet?
The workbook could not be opened, and the target cell addresses, source ranges, and expected results were not supplied. Reupload the file or provide those details for each highlighted cell.
Should I change the file extension to make the workbook open?
No. If the workbook opens in Excel, use File > Save As and choose a supported Excel file type, such as .xlsx, instead of changing the extension manually.
What should I send if the workbook still won't open?
Provide the worksheet names, highlighted cell addresses, relevant headings and sample values, and expected results. Also include the file type, storage location, Excel version, operating system, and any error message.
Can WPS Spreadsheets work with an Excel workbook?
Yes. Use Open in WPS Office to select a compatible Excel workbook, including an .xlsx or .xls file. The formula requirements still need to be supplied before the eight formulas can be created.




