Sharepoint By Dummies

See Also: http://stephenbooth.brandyourself.com/

Interesting, but annoying, behaviour of Excel with exported Sharepoint list

leave a comment »

You can export the contents of a Sharepoint view to Excel, this is handy for doing further analysis on the data, and maintain a link to the list so that when you synchronise the worksheet any new items will be brought through.

I have a list which contains a number of dates which I exported to Excel.  The data filled in A2 to J13 (A1 to J1 being the headers).  In columns K et seq I crested a number of formulas and used the fill down functionality to automatically copy the function down as far as row 166, i.e. much further down, my thinking being that as more data was populated from Sharepoint the functions would be there to pick it up.

So at this stage the function in K13 is =IF(C13=””,””,C13), this just redisplays the content of C13 but has different formatting applied,  and the formula in K14 is =IF(C14=””,””,C14), which is blank because C14 is blank (this is the purpose of embedding the thing I want to apply in the IF statement).  When I add an item to the list on Sharepoint and synchronise I expect K14 to display the new value, but it doesn’t.  When I now look in K14 the formula now reads =IF(C15=””,””,C15).  It is as if synchorising the list has inserted a new row, updated the formulas to keep them pointing to the same cell (which is now one row lower) but not moved the formula.  Wierd!

Advertisements

Written by stephenboothuk

July 20, 2011 at 4:56 pm

Posted in Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Speeches I Would Have Given

What I would have said at conference

three65.blog

Maybe mildy useful to someone!

David Hunt, PE... Mechanical Engineer on the loose!

VALUE = Creativity + Diverse Experience + Critical Thinking

Not Literally Productions

Comedy, parody, tutorials and more!

catastraspie

A personal blog about having Asperger's

Dementia and Elderly Care News

News and research of interest to people involved in Dementia and Elderly Care

Marc D Anderson's Blog

A Knowledge Management Zealot Speaks Out

Codeless Solutions for SharePoint

Bryon Wyly is a SharePoint Developer dedicated to finding the limits to out-of the-box SharePoint solutions

gordonlyew.wordpress.com/

the political blog of gordon lyew

SharePoint Business Analyst

Just another WordPress.com weblog

%d bloggers like this: