kevinparry1969
New Member
- Joined
- Sep 15, 2017
- Messages
- 4
Hi all,
I got into work this morning and now faced with a complete mystery.
I have a Excel 2013 file which contains queries from another Excel file.
It's been in use for the past 10 months and worked flawlessly up until this morning.
The part numbers we use mostly have letters and numbers eg PRE24LCOM
We also have part numbers which just contain numbers eg. 10011921
This morning all the lines that have part numbers that contain letter in them are showing the P/N field as blank.
All the lines which have P/N's that contain just numbers all show up fine.
Like I said this file as work flawlessly for the past 10 months and suddenly over night this issue comes up. Not changes done this side so I have a mystery to solve.
The data is queried using MS query. Anyone else had a similar issue?
I got into work this morning and now faced with a complete mystery.
I have a Excel 2013 file which contains queries from another Excel file.
It's been in use for the past 10 months and worked flawlessly up until this morning.
The part numbers we use mostly have letters and numbers eg PRE24LCOM
We also have part numbers which just contain numbers eg. 10011921
This morning all the lines that have part numbers that contain letter in them are showing the P/N field as blank.
All the lines which have P/N's that contain just numbers all show up fine.
Like I said this file as work flawlessly for the past 10 months and suddenly over night this issue comes up. Not changes done this side so I have a mystery to solve.
The data is queried using MS query. Anyone else had a similar issue?
