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?
Hi Melanie,
You have an error in a cell's formula, you have to fix that REF error in the source workbook.
For the date/time error, you should be able to change the source data to match the format, or change the queries.
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.
