I’m seeing a lot of referral traffic to this post searching for Excel 2010.If you’re simply looking for where you define or modify named ranges in Excel 2010 (as one commenter indicated in response to an earlier version of this update), it’s on the Formulas tab in the Defined Names area — Name Manager.When I publish and confirm to replace the existing data set the new columns do not show up on Power I think I asked about this before but can't find the thread. Will just have accept I have to watch to be sure it's behaving properly. Just my 2 cents: Every once in awhile, this happens to me. When it happens, I go to: Tools/Options/Calculation tab. All I do is change it to Automatic, and life is back to normal.When Q exports a table or chart to Power Point and Excel it scans the documents to see if the code is contained within the document and, if it is found, the option of updating is provided.This updating mechanism is relatively robust and can be used to update a document from multiple Q projects and also to update multiple different documents from a single Q project.This blog isn’t really focussed on all of the myriad ways that Excel can be contorted to represent data effectively, but I’m a big believer in using tools as effectively as possible to remove as much rote report generation as possible.There are lots of blogs devoted entirely to Excel tips and tricks.
One of the primary advantages associated with using tables in Excel is formula replication – formulas that automatically copy down a column in a table, even as the volume of data changes. I’ve made a new version of the post that takes advantage of Excel tables, which simplified the process a bit (it’s still kinda’ complicated).That post is available here.][This post is about dynamic named ranges in Excel 2007.If you are looking for other Excel 2010-specific information that this post doesn’t cover, please leave a quick comment as to what the change/issue is that led you to the search.Thanks.] I’ve had a pretty good run of theoretical posts about the nature of marketing measurement of late, so it seemed like I was due for a more down-in-the-weeds-Excel-efficiency-tactics write-up.