Why a sample file is important for troubleshooting. How to do it.

Scope: Office troubleshooting (written for Word but applies to Excel and PowerPoint)

Level: Beginner

Note: This is an Article that was created on the Microsoft Answers site that I saved so it could be edited. Despite appearances, it is not on a Microsoft site, now.

You have been asked to submit a sample document or file to assist with troubleshooting your issue. Why? How?

There is an old saying that a picture is worth a thousand words. Sometimes screenshots can help as well so we can see what you are seeing, yes. How to include a screenshot in your post

However, if a screenshot is worth a thousand words, an actual file may be worth ten thousand! Word and other Office programs have a multitude of methods that produce the same or very similar appearances on the screen. The actual file gives us a chance to look at the actual styles, and settings in the document. Some here delve into the underlying XML structure of a file when it is needed. None of that information is available with a screenshot and it may be crucial in helping you fix your problem or achieve your goal.

To try to help you, we need to figure out what is going on in the document (file).

  • We do not want your private information.

  • We do not want you to share confidential or proprietary information on this very public forum.

  • We do want to take a look "under the hood" though to diagnose your problems.

  • Dropbox works as well for sharing.

  • When you have your answer, if you want you can remove your file from OneDrive or DropBox

Creating a document that does not share confidential, proprietary, or private information.


This user-to-user support forum's heavy lifting is done by volunteers. When we try to recreate your problem numerous assumptions and guesses have to be made, often resulting in back-and-forth question and problem-solving stretching over days. You can get faster and better answers by supplying a sample.

  • The sample should clearly show the problem you are experiencing. You may need to start it with a couple of paragraphs saying where we should look for the problem.

  • It should be fairly short. Usually a few pages is all that is needed. We do not need you to post your thesis or book online to troubleshoot.


From Rohn's page: Trouble Shooting - Share OneDrive File

Excel Macro to Randomize Selected Data

.

A macro by Andreas Killer to anonymize data in selected cells can be downloaded here:

https://www.dropbox.com/s/rkfxuh85j5wyj9y/modAnonymize.bas?dl=1

.

The download is a .BAS file.  You can open it in any text editor to view the code.

Andreas's instructions for using the download:

  • Open your Excel file

  • Right-click on the sheet tab

  • Choose "View Code"

  • Press CTRL-M

  • Select the downloaded file and import

  • Close the VBA editor

  • Select the cells with the confidential data

  • Press Alt-F8

  • Choose the macro Anonymize

  • Click Run

.

This article shows 2 ways to load the macro code in a .BAS file

https://www.techwalla.com/articles/how-do-i-import-macros-for-excel

[end of quoted material]

I have been advised by Excel experts that DropBox is preferred. "Do not use OneDrive because we need a 1:1 copy!"

Sharing on DropBox or OneDrive:

You need to have one of these set up on your computer. Both offer free accounts.

Here are help pages on how to use these for file sharing:

VBA and code problems

If you are asking about a problem with a macro, provide the macro in your question and in your example document.

Here is a page in the Stack Overflow forum on what to provide when you have a problem with a macro:

How to create a Minimal, Reproducible Example - Help Center - Stack Overflow

Was this article helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this article?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this article?

Thanks for your feedback.

I have been advised by Excel experts that DropBox is preferred. "Do not use OneDrive because we need a 1:1 copy!"

Can you expand on what a "1:1 copy" is and how it cannot be provided by OneDrive?  Never heard of this "issue", so I'm curious what it could be.

.
*****
.
As computer scientists we are trained to communicate with the dumbest things in the world – computers –
so you’d think we’d be able to communicate quite well with people.
Prof. Doug Fisher

1 person found this comment helpful

·

Was this comment helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this comment?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this comment?

Thanks for your feedback.

99.99% of all photocopiers in the US introduce some distortion in size, clarity, color courtesy the US Treasury. Something about counterfeiting. I'm guessing OneDrive does the same.

2 people found this comment helpful

·

Was this comment helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this comment?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this comment?

Thanks for your feedback.

this is a sample page for a book outline. need to outline better for this and coming books in a series.

Chapter 2 - Building A Professional Team

 

Businesses new and established know that there are several types of professionals they will need to stay competitive and protect their operations. Finding the right professionals, from accountants to marketing consultants to lawyers can get challenging. Like employees, you need a good cultural fit in an outside service provider and consultant.

The importance of this chapter will become abundantly clear as you continue your purchasing process.A professional team to help make the odds of success grow exponentionally as the purchase progresses.  Therefoe, we want to do all that we can to avoid the pitfall associated with either weak or the wrong professional help. 

For instance, not all attorneys or accountants are interested in nor equipped to deal with small business issues. Just because it is Uncle Joe or a family friend who might step in to help, does not count as professional, unless they are specifically equipped to deal with the particular need of a small business. Searching out, interviewing, and engaging the right professional help is crucial.

Pro Team List:

                            1 Business BROKER

                            2 Small Business Attorney

                            3 Accountant Who Specializes in Small Business

                            4 Banker from a Bank that Caters to Small Business       

Section 1 Finding A Good Business Broker

Section 1 A  I’ll begin by explaining what a business broker’s role is, because most buyers and sellers of businesses use the services of a business broker. Keep in mind that if you don’t use a broker, then you as a buyer or seller, will have to be involved much more intimately in the hundreds of details of the transaction which will take a great deal of your time.

Section 1 B A broker’s typical commission is 8-10% of the total business selling price. As I’ll explain later, this may not be a wise move if you really want to purchase a business for a fair price in a reasonable time frame. However, you’ll want to read this chapter carefully whether you use a broker or not.

Unfortunately, some business brokers are not fully familiar with some of the concepts in this book. And so, it will help your position by being more knowledgeable than they are. If you do not use a business broker, then you are effectively operating in that capacity yourself.

 

As a matter of basic principle, all business brokers dealing with the public are bound to be honest and forthright in their conduct concerning the businesses and clients. They also have a fiduciary relationship (position of trust) to uphold between themselves and their clients.

Section 1 C Agency relationships in business ownership transactions involve the representation by a business broker (on behalf of a brokerage company) of the selling principal, whether that person is a buyer or a seller. The principal broker (and his/her agents) then become the agent/s of the principal, who is the broker's client. The other party in the transaction, who does not have an agency relationship with the broker, is the broker's customer. I would not be overly concerned about an agency relationship where both sides of the transaction are handled by one company or even one agent. On the one hand, a single agent handling both sides of the transaction puts more pressure on the agent himself or herself to nurture a deal to conclusion. Even though the seller of the business pays the commission, the buyer’s agent always has an incentive to help the purchase for the benefit of both sides because if the purchase does not take place, nobody gets paid.

Section 1 D The agent must present a business for sale in its “best light” without misrepresenting any facts. This is what could set up an adversarial relationship with the buyer. At times, you’ll find that a broker’s obligation as a fiduciary to the seller may appear to be at odds with their required conduct with prospective buyers.

Sometimes buyers hire their own business broker to represent them in finding and buying a business for sale. If a serious buyer can find a good professional business broker to represent them on a fixed fee (or hourly rate) basis, it may be well worth their money. Having a seasoned professional on the buyer’s side could mean a lower purchase price, and a more successfully financially structured deal that may help to ensure that the business buyer succeeds with the newly acquired business.

Section 1 E There is an increasing trend in business brokerage towards the use of transaction brokers. These are business brokers who basically represent both sides in the transaction. They act as facilitators to the business deal and are bound by fiduciary responsibilities to equally represent both sides; the buyer and the seller. Their principal value is to act as a facilitator, intermediarie, and problem solver. The transaction broker is paid a commission from both the buyer and the seller upon closing, but there’s almost always a negotiated fee paid in advance in case the transaction never completes.

Section 1 F Once you’re decide to retain the services of a

How to substitute existing data yet provide some way for me to find location ?

My suggestion is to replace with random characters except first character of each word?

This is my thought to scrub content but still help me find location of original content structure by first character of each word,,,

Thanks for volunteering & great support!

Was this comment helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this comment?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this comment?

Thanks for your feedback.

How to substitute existing data yet provide some way for me to find location ?

My suggestion is to replace with random characters except first character of each word?

This is my thought to scrub content but still help me find location of original content structure by first character of each word,,,

Thanks for volunteering & great support!

Thank you for the thought. For most people the Rand/Lorem solution is sufficient, though. What you propose would require a lot of work by the person asking the question. Instead, I would suggest putting text section like "LOOK HERE" and make sure the problem still exists.

Random Text Add-In

Volunteering to "pay forward" the help I've received in the Microsoft user community.

Charles Kenyon
Sun Prairie, Wisconsin
wordfaq[at]addbalance[dot]com

1 person found this comment helpful

Looks like your link to the Suzanne Barnhill MVP article on random text is redirecting to an NSFW site.

Was this comment helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this comment?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this comment?

Thanks for your feedback.

The link is working here. You may want to try in a different browser.

Random text can be generated by AutoCorrect. In recent versions of Word, any of the following will generate 1 paragraph of 4 sentences each of random text when typed into a blank line and followed by the Enter key:

  • =rand(1,4)

Video provides a powerful way to help you prove your point. When you click Online Video, you can paste in the embed code for the video you want to add. You can also type a keyword to search online for the video that best fits your document. To make your document look professionally produced, Word provides header, footer, cover page, and text box designs that complement each other.

  • =lorem(1,4)

Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Maecenas porttitor congue massa. Fusce posuere, magna sed pulvinar ultricies, purus lectus malesuada libero, sit amet commodo magna eros quis urna. Nunc viverra imperdiet enim.

  • =rand.old(1,4)

The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog.

You can also download a free Add-In from my site. It gives you a dialog box.

Volunteering to "pay forward" the help I've received in the Microsoft user community.

Charles Kenyon
Sun Prairie, Wisconsin
wordfaq[at]addbalance[dot]com

2 people found this comment helpful

I changed my file so there is no link anymore on behalf of privacy. Now I have to upload the file to get your help. I do not see any place where this upload can be done.

Was this comment helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this comment?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this comment?

Thanks for your feedback.

Look at the first post in this thread, specifically the section titled "Sharing on DropBox or OneDrive", for instructions.

_____________________________
https://jay-freedman.info

Was this comment helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this comment?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this comment?

Thanks for your feedback.

Not just copiers. I had a Christmas gift (don't remember what exactly) that you were supposed to put money in, but I wanted to just print a specimen bill. An inkjet printer I had would print it full sized if I used a lower resolution, but if I used the photo quality resolution, it would reduce it, which made the result too small to fit the gadget, whatever it was.

Microsoft MVP (Word) since 1999
Fairhope, Alabama USA
http://ssbarnhill.com
http://wordfaqs.ssbarnhill.com
Screen shots captured with TechSmith's Snagit

You found this comment helpful

*
Please select edit reason
 
 

Forum Article Info


Last updated April 29, 2025 Views 2,653
Top Content
Applies to: