Excel Cross-sheet reference not working

0 votes

A cross-sheet reference within the same file is giving me difficulties.

There are merged cells at D5:G5 on the second tab, "Disclosures & Identification," that include text.

There is a reference to that cell on the first tab. "="Disclosures & Identification" is the formula in use. D5. The formula just shows up in the cell rather than transferring the content from the field on the second tab.

I have tried using the entire set of combined cells in the reference (d5:g5), renaming the tab (in case the & was the issue), saving the file under a new name and updating to Office 2007 format (old version was 2003, but that should have worked anyway), and doing what I believe to be an appropriate amount of searching for the solution (with no luck). Any suggestions as to why this could not be working are welcome.

image of the two tabs and appropriate information

Nov 20 in Others by Kithuzzz
• 20,660 points
31 views

1 answer to this question.

0 votes

There are 2 possible things:

  1. Make sure the format of the cell is not 'Text'. If it is, change to something else, such as 'General' and then double click in the formula bar and press enter.

  2. Make sure that 'Show Formulas' is OFF. You can find the option under the tab 'Formulas'. Otherwise, you can use Ctrl+`

answered Nov 20 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

Excel MATCH function is not working on an array but works once directed to the matched value

According to the definition here: support.microsoft.com/en-us/office/… if you do ...READ MORE

answered Nov 17 in Others by narikkadan
• 37,660 points
27 views
0 votes
1 answer

Excel Consolidate Data not working - Data does not merge

This is so that letters cannot be ...READ MORE

answered Nov 17 in Others by narikkadan
• 37,660 points
33 views
0 votes
0 answers

Self Created Laravel Link Not Working

I installed laravel 6.0 through composer and ...READ MORE

Dec 3, 2019 in Others by anonymous
• 120 points
262 views
0 votes
0 answers

PhpMyAdmin not working on localhost

I had recently installed the Xampp version:1.7.7 ...READ MORE

Feb 8 in Others by Soham
• 9,670 points
54 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
109 views
0 votes
1 answer

Remove formulas from all worksheets in Excel using VBA

Try this : Option Explicit Sub test1() ...READ MORE

answered Oct 3 in Others by narikkadan
• 37,660 points
93 views
0 votes
1 answer

Calculate monthly average from daily data without PivotTable

Assuming you have the months in column D enter ...READ MORE

answered Oct 3 in Others by narikkadan
• 37,660 points
69 views
0 votes
1 answer

Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE

answered Oct 7 in Others by narikkadan
• 37,660 points
89 views
0 votes
1 answer

Force download excel file not working on web server

Change the content type to Content-Type: application/vnd.ms-excel Or try ...READ MORE

answered Oct 11 in Others by narikkadan
• 37,660 points
77 views
0 votes
1 answer

Excel does not show hidden sheet but if i unzip it, then there are 2 worksheets

I now know that an Excel worksheet ...READ MORE

answered Nov 12 in Others by narikkadan
• 37,660 points
32 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP