Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Ea month I have a payables worksheet with internal

Customer Question
Ea month I have...

Ea month I have a payables worksheet with internal hyperlinks imbedded. When I try to copy this month sheet to set up for next month, sheet copies, but hyperlink references are lost. Example. November sheet has hyperlink (or defined name), "Balance", which jumps me to A165 where my monthly balance is accumulated. But when I copy the Nov sheet to a new blank sheet, the link reference gets messed up. On the new sheet, monthly balance info is no longer at A165 ... and all hyperlinks (or defined names) have to entered over again from scratch. Appears to be a fundamental flaw in Excel software ... or am I just not setting up the new worksheet properly?

Technician's Assistant: Is your Excel file saved to cloud storage services like Dropbox, Google Drive, or OneDrive?

No

Submitted: 6 months ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Customer reply replied 6 months ago
Copy fails to retain jump settings whether original is hyperlink or defined names.
Answered in 3 hours by:
12/24/2017
Microsoft Office Technician: bbao, IT Consultant replied 6 months ago
bbao
bbao, IT Consultant
Category: Microsoft Office
Satisfied Customers: 1,797
Experience: CISM / CISSP / MCSD - Azure Solutions Architect / MCSE - Cloud Platform and Infrastructure / MS MVP
Verified

1. Can you please try copying from another month's sheet e.g. Aug or Feb to see if the problem persists?

2. Can you please share both the Nov sheet and your copy with missing links to here for review?

Thanks.

Ask Your Own Microsoft Office Question
Customer reply replied 6 months ago
No. Confidence in 30-minute guarantee is down to zero.Problem persists ... value of your help = zero. Issue me a refund immediately, and if you have any questions about Excel, let me know, I'll resolve them for nothing.Very dissatisfied!!
Customer reply replied 6 months ago
This site is a scam.
Microsoft Office Technician: bbao, IT Consultant replied 6 months ago
This site is not a scam. If you are to happy with the service please speak with customer service asking for a refund.
Ask Your Own Microsoft Office Question
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 NewITZone Your Own Question
NewITZone
NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
90 Satisfied Customers
Experience: I have been using Office Pro for 10 years and implemented applications for business use.

NewITZone 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 am having an issue with two workbooks that are linked to a
Good morning, I am having an issue with two workbooks that are linked to a MS access database. In the MS Access tables I have hyperlinks set to individual .pdf files. In Access, the hyperlinks that ar… read more
bbao
bbao
IT Consultant
1,797 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,797 satisfied customers
Currently I carry forward a balance from monthly file 2016-04
Currently I carry forward a balance from monthly file 2016-04 Bank Stmt.xlsx to file 2016-05 Bank Stmt.xlsx using cell contents 'F:\Bank Statements\[2016-04 Bank Stmt.xlsx]Main'!$P5 For next month I w… read more
Zabo04
Zabo04
Master\u0027s Student
Master\u0027s Degree
7 satisfied customers
I need a formula that will allow me to calculate data from
I need a formula that will allow me to calculate data from columns into number of daily visits by staff to clients seen per day. I have a column with date of visit, another column with staff name (e.g… read more
Zabo04
Zabo04
Master\u0027s Student
Master\u0027s Degree
7 satisfied customers
Looking importing the data from a master site list
looking for help importing the data from a master site list from one worksheet into the sales order template worksheet, and then generate a new worksheet for each row of information that is imported i… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
Hi , I have an Excel file of approximate 60 columns and 1500
Hi , I have an Excel file of approximate 60 columns and 1500 rows. I use it to record money that people give on a weekly base. In all there are 500 people and each takes 3 rows of information. The mon… read more
Adam B.
Adam B.
Senior Microsoft Systems Consultant
Bachelor\u0027s Degree
78 satisfied customers
Excel - i have the following code. im trying to merge certain
Excel - i have the following code. i'm trying to merge certain fields from multiple workbooks into one. i seem to get an error when i enter the filename and path. what am i doing wrong? Sub MergeAllWo… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,462 satisfied customers
I have two seperate Excel worksheets that have data that needs
I have two seperate Excel worksheets that have data that needs to be compared. Example: Worksheet 1 shows item numbers for seperate construction pieces. Worksheet 2 shows The item numbers (about half … read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
Thanks again for you help, next question, so for example that
Thanks again for you help, next question, so for example that I had a worksheet for each day of the month, could I possible do the same with the printable copy page?? if the person selected say worksh… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
842 satisfied customers
I have a spreadsheet that has some formatting and I am having
I have a spreadsheet that has some formatting and I am having difficulty with IF then statements and producing the actual number if it is true AND then copying that result to another worksheet… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
842 satisfied customers
When I use an excel file with multiple sheets, and I want to
When I use an excel file with multiple sheets, and I want to change to view or change a sheet other than the one I am viewing, by clicking on the tab at the bottom of the page, Excel opens that desire… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,462 satisfied customers
Hi. I am a teacher at a large school. Each year we make up
Hi. I am a teacher at a large school. Each year we make up new classes for the next year trying to have a balance of boys and girls, academic spread and behaviour spread. Each year we do this with a l… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,462 satisfied customers
I would like to include charts in MS Excel 2007 to bring my
I would like to include charts in MS Excel 2007 to bring my data to life. I have year over year volumes purchased by product per customer per quarter. I believe a bar or line chart would be good so i … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,462 satisfied customers
How do I select a cell with a dollar amount on sheet one and
How do I select a cell with a dollar amount on sheet one and have it automatically put the same dollar amount on sheet two and multiply it times .065% tax and apply it to a certain month on the second… read more
WesPCDr
WesPCDr
Master\u0027s Degree
170 satisfied customers
Hi, I have an Excel spreadsheet that is causing me grief.
Hi, I have an Excel spreadsheet that is causing me grief. It is copied from a previous month's and new data pasted into one of the worksheets. Therefore the formulas and settings should be identical, … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
PC running Office 2000 (Excel question) Sorting problem I
PC running Office 2000 (Excel question) Sorting problem I have a file that monitors attendance. Worksheet 1 is the master roster with additional info (Lastname, firstname, DOB, ID#, etc). Worksheet 2 … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am working in excel 2010I have created a number of work
I am working in excel 2010 I have created a number of work books with agendas I also have created a cove sheet which appears as the agendas where i can type in for example a name and it will show all … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Hello,I am very new to Excel and cannot get my head around
Hello, I am very new to Excel and cannot get my head around macros. It doesn't help that I am also blonde! I am using MS Excel 2003. I understand that my approach is probably not the most efficient, b… read more
John D
John D
Bachelor Degree in Engineering
342 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