Log In
Register
Home
May 29, 2019
Offline
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?
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
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.
May 29, 2019
Offline
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)
