I have a macro delete the data information and refresh the Pivot Table, I get #Ref!
I am using a macro to delete the data and refresh and using Excel10
It happens when I don't use all the fields in the Design input Box. There are times when I don't use all the fields.
For example sometimes I may not have coins. The pivot table is looking for an entry in the coin field. I have my report getting the total from the Pivot Table and in my report is where the #ref! appears. I can't post an attachment to show you to help understand my problem.
This is for a church. I have checks, currency and coins, name, amount and the fund to apply in the Design Box.
It will work if I make a dummy entry for all fields, but then they appear in the report. I can make an entry for a name "no body" make 5 entries to include all fields and filter "nobody" out but was hoping there is a better way.
I am using a macro to delete the data and refresh and using Excel10
It happens when I don't use all the fields in the Design input Box. There are times when I don't use all the fields.
For example sometimes I may not have coins. The pivot table is looking for an entry in the coin field. I have my report getting the total from the Pivot Table and in my report is where the #ref! appears. I can't post an attachment to show you to help understand my problem.
This is for a church. I have checks, currency and coins, name, amount and the fund to apply in the Design Box.
It will work if I make a dummy entry for all fields, but then they appear in the report. I can make an entry for a name "no body" make 5 entries to include all fields and filter "nobody" out but was hoping there is a better way.