https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/56248.aspxMon, 28 Jun 2010 08:30:39 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:56248gooner80https://www.infopathdev.com:443/forums/thread/56248.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=56248<p>Hi all,</p> <p>&nbsp;Sorry if this is totally the wrong place to ask this but I am really struggling with a couple of things.</p> <p>&nbsp;1) I have a SP list which I have exported to Excel, tab 1 being the feed owssrv(1), tab 2 being my nicely formatted report which is basically pooling info from tab 1 via =[insert cell numer] type formula. The problem I am having is I have recently changed the column ordering in my SP site. Just the order nothing else.</p> <p>&nbsp;So it&#39;s all good when I want to make a new list entry but my column order won&#39;t change on Excel when I refresh the list.....why is this and can you please advise how I can get around ?</p> <p>&nbsp;</p> <p>2) My second issue is to do with data validation on my SP list....but I don&#39;t think you can do it my version WSS ? As free text is not really ideal for a columm such as reference number (which I have a number format for)</p> <p>&nbsp;I hope you are able to help me</p> <p><br />Thanks and regards</p> <p>&nbsp;</p>