Free Microsoft Excel 2013 Quick Reference

Why does excel change my hyperlinks when I copy a worksheet?

When I copy a worksheet to a new book excel removes part of the hyperlink
directory tree from each hyperlink rendering them useless (the change is
identicle for all the links). Am I doing something wrong?


Post your answer or comment

comments powered by Disqus
When I copy a sheet in the workbook, I get a message about a name which
already exists on the destination sheet. I am puzzled. I cannot find that
name in the workbook by listing or doing a search in formulas. There are
several names like that. I had copied a worksheet one time from another
workbook which contained those name. How can I get rid of these range if I do
not find them in my workbook????

Why does excel convert my text for example "6990011011234" to "6.99E+12"?
I am runing a "import to excell" from a web site. When imported, the
identification # is changed to #.###E+##.

Why does excel convert my text for example "6990011011234" to "6.99E+12"?
I am runing a "import to excell" from a web site. When imported, the
identification # is changed to #.###E+##.

why does Excel see my simple formulae as macros now? Cells will not
automatically recalculate when that function is enabled. virus
scan/spyware/firewall all up to date and active. I don't use macros, so how
did Excel convert simple "divide this cell by that cell" into macros that
don't even work?

why does Excel see my simple formulae as macros now? Cells will not
automatically recalculate when that function is enabled. virus
scan/spyware/firewall all up to date and active. I don't use macros, so how
did Excel convert simple "divide this cell by that cell" into macros that
don't even work?

When I protect a worksheet, Excel does not let me use the check boxes I have created. When I click on a check box, a message comes up saying the sheet is read only and I therefore cannot use the check box. I have tried unlocking the check boxes and even unlocking the cells the check boxes are in, but still, the same message appears. I just don't know a way of making them work - even my IT teacher couldn't help me!!

When I save a worksheet made in excel 2003 to excel 97, my excel program
crashes.

Anybody else having this problem? (Excel 2007, Windows 7). When I open a pre-existing Excel file by clicking on the file, two windows open: the spreadsheet AND a second Microsoft Excel window (no spreadsheet open--just a blank Excel Window).

When I open the Excel program directly, I get the single window (Book1). But opening Excel from a previously created file always gets me two windows.

Word 2007 does this too, but not consistently.

Any suggestions?

Hi! Well this has been a humdinger! It seems completely illogical.

I have a worksheet that calculates various dates.

You enter the date the student pack was sent out (via the post). This cell is then read by another which calculates a start date 5 working days later, taking into account a list of holidays. That cell's (I7) formula looks like this:

=(WORKDAY(I7,5,AF3:AF133))

A timetable containing deadlines is then created using similar formulas.

There are multiple worksheets containing these formula and they all work fine.

However, when I attempt to either insert a new worksheet and copy and paste the contents of an existing one into it, or, if I copy an existing worksheet, the cells that read I7 to calculate deadlines etc show the following error if you change the date the student pack was sent out:

#NAME?

All the formulas are the same in the copied worksheet - so how is this error occuring?

Please note that this file was originally put together using OpenOffice.

I hope someone can help me with this!

Many thanks

Stig69

When I copy a table that i have built in a worksheet and then paste it into another worksheet, I am losing all the formatting for that table. It pastes only the data. Fonts, highlighting, borders etc are all dropped. There must be an option that can be selected to control this. I have an old laptop with Excel 2007 that retains the formatting. But I have been given a new laptop with the same software and the formatting is not retained, but I can't see what option is controling this. Any help is appreciated. thanks

I am now having a problem that has never happened before. When I copy a
formula from one cell to another, the copied cells show the value of the
original cell. I have tried the special paste option and that doesn't work
either. How can I fix this? Help

WHEN I "COPY" A CELL WITH A FORMULA THE RESULT IS COPIED NOT THE FORMULA WITH
THE REVISED REFERENCES. HOW DO I COPY THE FORMULA WITH THE REVISED REFERENCES
TO THE NEW CELL?? I AM UNABLE TO USE THE "PASTE' FUNCTION AS IT IS "GRAYED
OUT". I HAVE OFFICE XP VERSION 2002.

When I copy a worksheet with a graph or just copy a graph and paste in
a new worksheet, the source data is still linked to the original
worksheet.

I've tried editing the sorce data to remove the sheet name to try to
make it relative to the current sheet, but that gives me "Error in
your formula".

Is there a quick way to get the graph to link to the data in the new
worksheet? Even a macro would help, if that's what it takes.

Thanx in advance...

I am trying to do something that I thought would be easy (and I've simplified it!)

I have a list of numbers in Column1 of a worksheet.
I want to specify USING VBA that the formula in cell(4,4) of that sheet should be a SUM of all the cells in column1.

If I manually select a cell in Sheet1 I can type in it:

=SUM(C1)

This works fine, and I get the result as expected.

However my one line macro doesn't work:
For some reason when VBA puts this into the Excel cell, Excel decides that actually it would prefer the formula to be:

=SUM(R[-3]C[-1])

Which of course gives the wrong result.
Does anyone know why this is happening?

I've attached an example to illustrate the problem.
In Cell(5,4) i have manually typed in "=SUM(C1)", and cell(4,4) is where the VBA code trys to put in the identical formula.

Many thanks!

I downloaded a template for Excel to my computer. When I use the template,
the colors in other workbooks change. After I reboot, it all goes back to
normal, until I open the template again.

My spreadsheet is no longer able to calculate the correct answer when I copy
a formula from 1 cell to another. Or even when I change the value in a cell
it does not change the answer. It seems to work fine when I put the formula
in the specific cell, but if I copy it from elsewhere into it, it does not
work.

I originally typed in this formula in a cell:
-360/12*1.03

Although Excel calculated the answer properly, it changed my formula to:
-30*1.03

I've not encountered this phenomena before.

Why does excel keep replacing the letter M with a 1 every time it is in a
cell by by itself example

i type cl-m in a cell
excel automaticaly replaces my m with a 1

why is it doing that

i tried to retype sometihing else cl (m) and excel replaces my m with a 1

this is very frustrating.

PLEASE SOMEONE HELP

Why does excel use different denominator when calculating variance and
covariance? When working with samples it should be "n-1" in both cases. Just
"n" when calculating covariance is by my humble opinion wrong.

In MSExcell 2002 SP3. In a cell I enter a string of numbers, ie..1658618353,
then when I leave that cell or hit "enter" the last number chages to "0"
ie... 1658618350.
I have tried reformatting the cell, deleting the info and re-entering it,
and everything I could find in "help".

When I copy a spreadsheet to another workbook, the data values all change by
4 years backward.

In MSExcell 2002 SP3. In a cell I enter a string of numbers, ie..1658618353,
then when I leave that cell or hit "enter" the last number chages to "0"
ie... 1658618350.
I have tried reformatting the cell, deleting the info and re-entering it,
and everything I could find in "help".

When I enter a 17 digit number in a cell in Excel, the last 2 digits turn to
00 when I leave the cell. Format - Cell does not have a setting to stop this
'feature'. How do I make Excel recongize the large number?

WHEN i OPEN A WORKSHEET THAT DOMEONE HAS SENT ME, EXCEL AUTOMATICALLY ADDS
THE REVIEWING TOOLBAR TO MY SCREEN. i DON'T WANT THE REVIEWING TOOLBAR OPEN.
HOW CAN I PREVENT EXCEL FROM SHOWING ME WHAT IT WANTS ME TO SEE. I KNOW
BETTER THAN MICRO-SOFT WHAT I WISH TO SEE, AND I DO NOT WISH TO EVER SEE THE
REVIEWING TOOLBAR.


No luck finding an answer? You could always try Google.