excel referencing not working

[opeyemi1]

Hello,
I hope you can help with this.

I have an excel workbook. It must have a macro because anytime I open it it prompts for me to disable or enable macro. I always enable.

There are a few worksheets in it. The worksheet I am working on is GA4. In column BE2, I clicked the = sign and went to tab GA3 and clicked on BW2. So, the formula is =GA3!BW2

I need to draf this down to line 80. There are values in GA3 bw2 to bw80. But it returns 0 for all of them. I have checked tools-options-calculation-automatic is set.
I also tried going into each cell in GA4 and clicked enter, but still doesn't work. I have tried f9, saving, reopening the sheet and shutting down and restarting my computer. What could be wrong?
Thanks for your help!

[rwgrietveld]

... and if you do this ='GA3'!BW2 and drag down?

Do you use the macro's, otherwise you could get rid of these by deleting the Forms/Classes/Modules.
Press Alt-F11 (VB Editor). Ctrl+R (Project Explorer).

If there are modules then right click and Remove. Export .. No.

If this does not work, then upload (part) of the Workbook.

[teylyn]

what happens if you select to disable the macros when you open the file? Does the formula then deliver the correct result?

What is the format of your target cell? Set it to General. Does that make a difference?

[opeyemi1]

thanks,

I noticed that when I reference another worksheet, say GA2, it's pulling it correctly and not just showing all 0s. I think we need the macro, though I am not sure what it does. So, the problem is definitely with the GA3 worksheet.
In GA4, when I click on the cell that I have the formula in, it has a green check besides it. And when I click on it, it gives me the following:
unprotected cell, fix error e.t.c.

[opeyemi1]

In response to teylyn,

I saved the workbook into another name. When I open it by disabling macros, the formulas in the entire worksheet are not working, everything comes out to 0. But the funny thing is tha tthe sum totals are the bottom still have numbers to them.

Thanks.

[teylyn]

OK, if you need to keep the macros, you'll have to find out what they do and see if they may be the reason for the strange behaviour.

[rwgrietveld]

I seems to me that there are user defined functions.

Could you tell us what the formula is that give 0 as a result?