Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

This answer was rated:

I am working with Excel and Word 2013. I have recreated

I am working with...

I am working with Excel and Word 2013. I have recreated approx. 15 spreadsheets within one Excel file that has come from multiple users that is linked to a Word document (report). The report and Excel spreadsheets are currently working correctly and are updating in real time on my computer; however, I am trying to find the easiest way to duplicate or recreate a new report/new Excel (the new report and new Excel spreadsheets working together) without the new report trying to pull from the original Excel worksheets. Thank you for your time and expertise.

Technician's Assistant: What Operating System (OS) are you running on your computer or device?

Microsoft 2013

Technician's Assistant: When did you last update your Excel?

A few years ago

Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 36 minutes by:
3/24/2018
bbao
bbao, IT Consultant
Category: Microsoft Office
Satisfied Customers: 1,971
Experience: CISM / CISSP / MCSD - Azure Solutions Architect / MCSE - Cloud Platform and Infrastructure / MS MVP
Verified

Do you mean you are using an Excel workbook to populate data into a Word file, and you have done so for 12 pairs of Word + Excel files, then you want to work out a method to automatic way to pair the Word and Excel files?

Ask Your Own Microsoft Office Question
Customer reply replied 4 months ago
I have one Excel workbook that has approx. 15 spreadsheets that populate data into one Word doc/report. I am trying to copy or duplicate the process without the new report pulling from the original excel spread sheet. Make sense?

> copy or duplicate the process without the new report pulling from the original excel spread sheet.

Do you mean you want the final report disconnect the data connection with the source data, so it can be opened on its own?

Ask Your Own Microsoft Office Question

If my understanding is correct, I will accept your remote assistance request. Thanks.

Ask Your Own Microsoft Office Question
Customer reply replied 4 months ago
currently, when I try to copy and paste a file folder that has the original Word Doc (report) and original Excel File (that has 15 spreadsheets) to create a new file for a separate client, it is not working. the links within the new report pull from the original excel file and not the new excel file

Okay, do you mean you want to prevent the copied Word file from using absolute reference to the linked data source, so if you copy set A (including one Word and one Excel with 15 sheets) to set B, all files of set B will work separately (no links to set A). Correct?

bbao
bbao, IT Consultant
Category: Microsoft Office
Satisfied Customers: 1,971
Experience: CISM / CISSP / MCSD - Azure Solutions Architect / MCSE - Cloud Platform and Infrastructure / MS MVP
Verified
bbao and 87 other Microsoft Office Specialists are ready to help you
Ask your own question now
Customer reply replied 4 months ago
to confirm what you are saying, I need Set B to link and operate the same as Set A; all linked Excel spreadsheets and cells need to populate into Set B's Word Doc with new entered data from Set B's Excel spreadsheets. Please confirm.
Customer reply replied 4 months ago
this system needs to allow the end user to recreate new reports/excel files that is repeatable; i.e. each new client needs its own Word doc and Excel file that links the same as Set A. Set A needs to be repeatable hundreds of times. thank you

Thanks for requesting remote assistance. Please click HERE from your Windows computer to start remote session with me.

Ask Your Own Microsoft Office Question

All done. Solution given and demonstrated via the remote session.

Ask Your Own Microsoft Office Question
Customer reply replied 4 months ago
You deleted 30 some Word doc pages within the test groups. What is up with that?

Yes, to remove the references to other Excel files in order to speed up opening the Word file.

Your final document should not be based on those Set folders, which are for test only!

Ask Your Own Microsoft Office Question
Customer reply replied 4 months ago
I have to go back to Set B and make all the code changes within the Word Doc that match what we did on the first page?

No. Set B folder is also for test only. You should work from your original documents.

All SET folders are for test only, we may have make some changes there. Delete all of them.

Ask Your Own Microsoft Office Question
Customer reply replied 4 months ago
to confirm. you want me to delete all sets (b, c, d, e) and work the new code into the original Word Doc?

Correct. You already know how to change the code fields, why do you still need those SET folders?

Ask Your Own Microsoft Office Question
Customer reply replied 4 months ago
true. just confirming
Customer reply replied 4 months ago
do I still need to point code within Original Report to Set B excel file? And then replace Template FAI Excel with Set B within file?
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a microsoft office technicianLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask bbao Your Own Question
bbao
bbao
bbao, IT Consultant
Category: Microsoft Office
Satisfied Customers: 1,971
1,971 Satisfied Customers
Experience: CISM / CISSP / MCSD - Azure Solutions Architect / MCSE - Cloud Platform and Infrastructure / MS MVP

bbao is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

842 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

653 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

Kamil Anwar

Kamil Anwar

Office Specialist

219 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

IT Miro

IT Miro

Computer Scientist

160 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

< Previous | Next >

Related Microsoft Office Questions
I want to write a macro for an employee list that will copy
I want to write a macro for an employee list that will copy the entire row of employee data to a second spreadsheet based on the input of the employee ID number. … read more
Jason Jones
Jason Jones
AAS Information Technology
6,327 satisfied customers
I have an excel question. I have a database download
I have an excel question.I have a database download worksheet with data sorted in columns. The first column is the all model numbers with multiple part descriptions for each model (i.e. 30-40 parts wi… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
I'm new at setting up a userform in excel. What is the code
I'm new at setting up a userform in excel. What is the code for getting a blank cell to return a zero to my worksheet? … read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
I created an Excel worksheet. The preview on the screen is
I created an Excel worksheet. The preview on the screen is exactly what I input, and want, but when I print it the text in the cells is different and chaotic. For example my input in the cell is "Date… read more
Josh
Josh
It Support Specialist
Associate Degree
5,156 satisfied customers
I am looking for a formula (index match match I assume) that
I am looking for a formula (index match match I assume) that enters the sum of column H on another worksheet (let's call it Sheet2). For instance I want to match cell A3 (last name, first name) on She… read more
bbao
bbao
IT Consultant
1,971 satisfied customers
Is there a way to send different portions of an excel
hello. is there a way to send different portions of an excel worksheet to different ms outlook recipients?… read more
robert
robert
Bachelor's Degree
2,594 satisfied customers
Needing help to pull data from an Excel report into a word
Needing help to pull data from an Excel report into a word document. Basically to create a pull ticket for PTA spirit wear order fulfillment. The spreadsheet contains columns of merchandise with the s… read more
Bhavik Joshi
Bhavik Joshi
Computer Science and Engineering
939 satisfied customers
1. How do you modify an Excel worksheet that's embedded in a
1. How do you modify an Excel worksheet that's embedded in a Word document? A. You must select all the cells in the embedded Excel spreadsheet. B. You must rename the document to gain access into the … read more
comp_audio
comp_audio
Microsoft 365 Ambassador
211 satisfied customers
I have created a spreadsheet in Excel 2013 to which I will
I have created a spreadsheet in Excel 2013 to which I will continue to add data. I saved the document without incident. Now when I open Excel, the document only opens as a window above the Excel icon … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
842 satisfied customers
I am having difficulty PDFing a Word file that has links to
I am having difficulty PDFing a Word file that has links to Excel. The print preview looks fine but the PDF process distorts (shrinks or enlarges) the tables.… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
I have a file with 201 client #. I have a template that requires
I have a file with 201 client #. I have a template that requires me to put in the client # XXXXX select the generate button to print the report. What I need is for it to look up each client # XXXXX an… read more
ragankel0323
ragankel0323
Field Service Engineer III
Master\u0027s Degree
58 satisfied customers
I have several Excel spreadsheets for which I need to combine
I have several Excel spreadsheets for which I need to combine data. I have one spreadsheet that has customer addresses. I have another spreadsheet that has sales by customer by product category for YT… read more
robert
robert
Bachelor's Degree
2,594 satisfied customers
Hi,Is there a means in Excel 2007 to collate text data,
Hi, Is there a means in Excel 2007 to collate the raw text data (which will be updated over over time such as names, places and ages. Some of which will be repeating information) onto a different spre… read more
Jason Jones
Jason Jones
AAS Information Technology
6,327 satisfied customers
Can someone please help with this in Excel. I have a
Hi can someone please help with this in Excel. I have a spreadsheets with 1000s of rows. there are four columns I need to work with. 1) ID 2) Unique work work orders 3) Date In 4) Date Out There can b… read more
Ryan-CTech
Ryan-CTech
Manager
279 satisfied customers
Question 1 When you first open an Excel workbook, by default
Question 1 When you first open an Excel workbook, by default the program displays __________ blank worksheet(s). A. 1 B. 2 C. 3 D. 4 Question 2 Which one of the following statements about an Active Ce… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
I have to build an excel spreadsheet to calculate interest
I have to build an excel spreadsheet to calculate interest due. My first worksheet consists of a list of all the principal amt and each start date for int. The 2nd worksheet has a 2columns..first colu… read more
Nick
Nick
27 satisfied customers
Im embedding a word document into Excel so that the updates
I'm embedding a word document into Excel so that the updates to the word document reflect in the excel document. The problem is the format of the word document once it is embedded is not right and I c… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,131 satisfied customers
I want to record a macro so I can take specific data from a
I want to record a macro so I can take specific data from a spreadsheet in excel and paste the data of a specific cell into word. I want to be able to change the data a enter new names in the excel do… read more
CompuNerd
CompuNerd
12 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x