SQL Data Into Excel

Hi all

I am currently creating a spreadshhet using SQL as my datasource i have imported the data and set it to refresh on open and users can also perform a background refresh.

The problem that i am having is when i have imported the data and sized the columns appropriatly everytime i refresh the data the formating i placed on the sheet is lost, is there a way to prevent this from happening?

John
pepps11976Asked:
Who is Participating?
 
Arno KosterConnect With a Mentor Commented:
There is a way :

click on a data cell
click on "Properties" in the data - connections tab
remove the ticks for  'keep cell formatting' and 'adjust column widht'
0
 
pepps11976Author Commented:
What a Star Thanks very much
0
 
Faisal KhanCommented:
are you doing via vba? try using cell.value i.e, sheet1.cell(x,y).value ="123456" instead of sheet1.cells(x,y)="123456"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.