Formulas Not Working - Source is in Hidden Columns

bjh894

New Member
Joined
Feb 27, 2011
Messages
9
I have a Workbook that has multiple Worksheets. On one worksheet, I have several formulas that are pointing to a different worksheet where I have hidden those columns where the data exists.

If I unhide those columns on the source worksheet, the formulas in the 'other' worksheet work just fine. When I hide those columns, they do not work. Is there a workaround for this?

Any help would be greatly appreciated.

Brian
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

ChrisBM

Board Regular
Joined
Sep 22, 2014
Messages
215
What are the formulae that are not working?

It is probably fixable in the structuring of the formula :)
 

bjh894

New Member
Joined
Feb 27, 2011
Messages
9
Okay... I figured out what I did. I deleted a couple of those important columns on the Source Worksheet instead of hiding them. I VERY MUCH appreciate your willingness to help me out. I'm self taught in Excel and sometimes struggle. Thanks for responding.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,538
Messages
5,529,430
Members
409,876
Latest member
Akash Yadav
Top