Share this content

Excel

Links to word docs

Didn't find your answer?

My question: is it possible to create a spreadsheet to link the word counts from various word documents to give a total word count for all documents, that will update automatically when the word document is amended.

Hope that makes sense!

At the moment I have to manually type the new word count in my table when the word document is edited. The word count is shown in file properties so surely it is possible to create a link to pick this data up? 

 

Replies (10)

Please login or register to join the discussion.

Simon Hurst
By Simon Hurst
10th Oct 2016 12:06

It would be nice if the Power Query/Get & Transform (Excel 2016) tools made this simple but, as far as I can see, you can only access the general file properties using the built-in functionality. Unless anyone else knows better, I think getting at the specific properties such as Word Count would require the writing of some VB code to extract the relevant property of each file.

It is possible to display the Word count as a column in a File Explorer window by right-clicking a column heading in the window and choosing the Word Count property in the 'More' list.

Thanks (0)
Replying to shurst:
joe
By Smokoe Joe
10th Oct 2016 13:53

Many thanks, that is useful - I thought at least I don't have to open the document now to get the word count, but on looking the count shown in Explore is significantly less than in the document!

Per Word Per Explorer Difference
Document 1 4709 3759 950
Document 2 5519 4364 1155
Document 3 5444 4291 1153
Document 4 4380 3529 851
Document 5 5493 4319 1174
Document 6 4437 3457 980
Document 7 3933 3030 903
Document 8 4703 3744 959
Document 9 4209 3590 619

42827 34083 8744

It is frustrating that Office products don't have a more uniform command structure, and also that you can't link fields to data that is readily available!

Used to be able to format too before the "Improvements" to the site!

Thanks (0)
Replying to Smokoe Joe:
Simon Hurst
By Simon Hurst
10th Oct 2016 14:10

Yes, when I was checking alternative approaches I came across some discussion of how innacurate the Word word count seems to be. The count in Explorer seems to ignore any words in a text box for example.

Thanks (0)
Replying to shurst:
joe
By Smokoe Joe
10th Oct 2016 15:47

Hmm, I've check three paragraphs in word and the count is accurate, hyphenated words counting as one, so I assume the count for the document is accurate.

There are no text boxes, etc, just plain text.

There are lots of speech marks, is it possible file explorer ignores text in quotes? The differences are substantial!

Thanks (0)
Replying to Smokoe Joe:
Simon Hurst
By Simon Hurst
10th Oct 2016 16:07

I don't think it will be quoted text. The Explorer total doesn't seem to update until you exit the document and refresh the Explorer view. I've also seen it suggested that if you go to the Review Ribbon tab, Proofing group, Word Count option, as well as letting you decide how to treat text in text boxes and footnotes and endnotes, it will adjust the total reported in Explorer.

Thanks (0)
Replying to shurst:
joe
By Smokoe Joe
10th Oct 2016 16:21

I really appreciate your help

I did the review, word count option, I didn't change anything but unless I clicked save when I closed the document it didn't update the word count in explorer so I click save on all and it did, most now agree, some are just a few out but none more than 100 words now!

Thanks (0)
Replying to Smokoe Joe:
Simon Hurst
By Simon Hurst
10th Oct 2016 16:46

Thanks. Glad we've got a bit closer to a consistent count.

Thanks (0)
Replying to shurst:
joe
By Smokoe Joe
11th Oct 2016 16:26

Just to round off, I have been in to each document, clicked in the text, done review/word count, clicked close, saved when prompted and now all match exactly in explorer to word count in word, hurrah!

So while I cannot automatically update my spreadsheet I can at least see all on one screen in file explorer, with excel open on my other screen it is easy to ensure my spreadsheet is up to date without having to open all the documents each time - so many thanks again.

Thanks (0)
Replying to Smokoe Joe:
Simon Hurst
By Simon Hurst
11th Oct 2016 14:52

That's great - thanks for letting us know.

I'm glad that we got some way towards what you wanted - I'll look out for any future updates to Power Query that let you get at the extra properties directly from Excel.

Thanks (0)
Replying to shurst:
joe
By Smokoe Joe
11th Oct 2016 11:29

still doing the duplicate posts!

Thanks (0)
Share this content