How to use XLStylesTool resources

The number of people reading this blog and downloading apps is rapidly growing worldwide. XLStylesTool by far is the most popular. Several users asked similar questions. I’ll try to cover four most frequently asked in this post:

Application won’t start or displays an error message. This was reported by couple of users that have older Windows XP or Vista machines. Windows 7 PCs have .Net3.5 pre-installed (hint: time to upgrade OS). On a more serious note if after you downloaded, unzipped and launched either the .Net3.5 or .Net4.0 XLStylesTool application version it didn’t start or you got error message that looks like one of these: No .Net3.5 Runtime on PC error message or No .Net4.0 Runtime on PC error message then you absolutely need to install appropriate for the XLStylesTool version .Net runtime. Get them here: .Net3.5 Client Profile for the original version of the application or .Net4.0 Client Profile for the latest version (Recommended).

Why do I get “File contains corrupted data” error message when I drop my file in the app window? Just when I thought I can’t keep up with questions covering various corruption scenarios (I have a day job) I got help from the user community: Teresa published her experience that spanned across multiple versions of Excel here.

What settings should I choose? Another user Liana went as far as setting up a dedicated XLStylesTool resources page. Looks like a “beta 2” version, but hey, we all get this for free and it beats the contents of my terse in comparison ReadMe file. I think that her idea to create a “How to” video is great. She managed to cover all important facts about the XLStylesTool and Excel copy/paste errors in less than 7 min! I suspect that her clients subjected her to many complex workbooks. Just a wild guess on my part :).

So, if after you read the ReadMe file enclosed with the application you still have questions regarding how to use it start with the posts from these two users. If you don’t find the answer you are looking for please post your question and I will answer it as soon as I can.

I want to thank Teresa and Liana for their contribution to the project aimed at eliminating the "Too Many Different Cell Formats" error message related frustration worldwide.

Why do files located on some network shares take long time to scan and same files copied to a local drive or another share scan in seconds? I had to setup couple virtual machines to really see what was going on here. Conclusion: this reported issue has nothing to do with the application code. However, for best performance avoid processing files bigger than 500KB located on network shares with mixed operating systems. Copy large files locally to your C: drive and then use them in the application. This network rule applies to situations when you run the app on Windows Vista, Windows 7 or Windows 2008 server and pull your files from file shares on Windows 2003 server or linked Windows XP PC. Here is why: something major got changed in the way Win XP/Win2K3 Server and Win 7/Win2K8 Server read files from mixed OS networked computers. So, when the file scan from a network share takes a while, just make a local copy. Learn something new every day. Thanks for reporting this.

This entry was posted in Computers and Internet. Bookmark the permalink.

18 Responses to How to use XLStylesTool resources

  1. Mr WordPress says:

    Leave feedback please

  2. Pingback: Sharing useful utilities | XLGeek's space

  3. Dan Harmeyer says:

    HOw do i get xlstyles tool for windows 7?

    • XLGeek says:

      Hi Dan, just click on the hyperlink button below the picture ‘XLStylesTool’ (between ‘Home’ and ‘About’). It will take you to the .Net4.0 app post that has links to multiple versions of the app.

  4. B says:

    how do you use it to fix the “too many cell formats” issue?

  5. Hello!
    I have used the Tool hundreds of times about 1 out of every 5 that I process, the application doesn’t end up working correctly. It appears to process without any error message, but when I try to paste in data, I still get “Excel cannot paste the data” (with the infuriating “Was this helpful”?” link) and when I process it again, it still doesn’t fix anything.

    Do you have any advice or options that I should try?

    • XLGeek says:

      This could be a result of a number of things. My app removes bad styles which is the primary cause for this message in a lot of cases, but not all of them. Please make sure both the target file and destination file are clean and are the only files currently open in a single Excel instance during the copy/paste operation. You also may have this behavior if you are trying to copy something huge or if there is an active X control that is being disabled by a kill bit. There may be other reasons. Impossible to tell without exactly replicating your steps. What version of Excel are you using? If you can share your files (source and destination) I can check them out. I won’t need numbers or text – you can convert all numbers to 0s.

  6. C.B says:

    Thank you for XLStylesTool, it’s a dreamware for me.
    I wish if you can add one more optional function for cleaning up Unused Custom Number Formats.
    I have been using a separate macro to do this but its better if you can integrate into XLStylesTool.

    • XLGeek says:

      Will look into it. People like to keep custom formats even if not used. I haven’t seen significant file size impact. How many unused formats do you typically have?

      • C.B says:

        Thank you for your reply.
        When we co-work on workbooks or use previous project workbooks as a template, I see up to around 20 or so very funny custom formats most likely being a result of trials and errors not being deleted.
        I do see a point in people prefer keeping Custom Number Formats even not in use. Therefore, any function of deleting unused ones seems better to be an optional function, not as a default function.

  7. Conan says:

    Hi, How are you? thanks for xlsytyles tool. Very happy for this application. I have a questions.
    XLStylestool didin ‘t work on windows 10. I downloaded windows 10 app and open app. get excel files and later clic prosess. But didint any do it.

    • XLGeek says:

      It is the same algorithm in Win8+ store app. It works really fast, so hard to see the progress bar. Are the before and after stats the same? You can send me sample file to validate.

      • Conan says:

        Yeah its working with 10 the app, but I select excel data and put process button. I am waiting and diidnt any work. old version (for windows 7) working put process program is opened excel and I saved file and excel is clean. But didint open windows 10 xlstyle tool excel process.

      • XLGeek says:

        Win8+ app is restricted by the OS from opening other apps. File is fully processed and saved on disk. It works very fast. I described it in the win store app post.

  8. Steve Harkins says:

    Is it possible to get the tool outside of the Windows Store? I have a user that had this app on Windows 7 (downloaded before the Windows Store days), and now wants it on Windows 10. The thing is, we block the Store in our firewall, and by GPO, so he’s unable to get it. Thanks!

    • XLGeek says:

      Can you use organization app store? Much more secure distribution option for Win10.

      • MickGerm says:

        I have the same issue, company doesn’t want to engage with the app store and so I can’t use this tool anymore after the organization upgraded our laptops to Win10 from 7 : ((( this is really frustrating, my excel files slowly deteriorate.

Leave a Comment or Ask a Question

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

You are commenting using your 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 )

Connecting to %s