make in registry editor for excel typeguess rows= 0then it will consider datatype using all the data inside column but it may be huge performance issue

but i know it resolves...