Formulas Not Working - Source is in Hidden Columns

[bjh894]

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

 

[ChrisBM]

What are the formulae that are not working?

It is probably fixable in the structuring of the formula

 

[Special-K99]

What formulas are you using?

 

[bjh894]

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.