

May 29, 2019

I am getting data format errors (#REF!) and (30/06/18) when I refresh the data input for my dashboard. Do I fix within the data source spreadsheet or the query? and how would I do that? I seem to be having trouble making any amendments "stick", as in they revert back to the original input.
For example; the date of 30/06/18 is showing as an error. This is the correct date and is the same across all data and queries. It is the Hours data source that is wrong, which is missing the 0 of 06. Do I change everything to match without the 0?
And is it the date error that would be causing the #REF?









May 29, 2019

Hi Catalin,
Thanks for replying.
I just couldn't figure it out when I posted yesterday, really couldn't see the wood for the trees, but that is it fixed.
It was the date format for the column header 30/6/18, so changed the format, re-typed the date to 30/06/18 which stayed as it was, then refreshed data.
The #REF was one formula in my Cost data source, which I didn't realise at the time, but if I had paid attention, the queries list was telling me this!!
Feeling rather foolish, but glad sorted.
1 Guest(s)
