File Cannot Open

Open the Excel Workbook and Create Formulas for Highlighted Cells

Camila MilosovichCamila Milosovich Nov 18, 2026 868 views

Question details

The user needs eight formulas for highlighted cells in an Excel workbook that could not be opened.

Open the Excel Workbook and Create Formulas for Highlighted Cells
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.
Before you start

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.

Solution 1Recommended

Reupload the workbook with a shorter file name

Use this approach when the uploaded workbook cannot be opened for review.

1
Check the original file

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.

2
Save with a shorter name

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.

3
Upload the new copy

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.

4
Describe the formula requirements

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.

Reupload the workbook with a shorter file name
Formula details are required: The eight formulas cannot be determined from the worksheet names alone. A shorter file name may help with the upload, but it does not repair a damaged workbook.
Work with Excel formulas in WPS

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. 1. Open the workbook: In WPS Office, select Open and choose the Excel workbook.
  2. 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. 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. 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.
Inspect highlighted cells and their worksheet referencesEnter and edit formulas in a spreadsheet interfaceOpen and save compatible Microsoft Excel formats, including .xlsx and .xlsUse a familiar interface to work with existing workbooks
microsoft office alternative - wps office

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.