Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Copy paste problems excel 2007 Results

The first question- is there a quick fix to this problem? I have created an error report that references mutiple excel sheets in our company shared drive (I:). I save at night after working with it and building it out and it still says (I:) in all the formulas. I come in the morning (my computer auto reboots at night to install any updates) and all the (I:) references have changed to (C:). This of course, blows out all of my formulas.

Secondly. Is there a quick fix to this issue? We have a report that was orginally built in Excel 2003. we recently integrated to 2007. This report uses multiple tabs that have information constantly being added and deleted by a manual process. recently, this report started blowing up in the morning (it is run and opened out an Access routine). It reports this message "Excel found unreadable content in SummaryReport.xlsx". It then goes on to report that "Excel was able to open the file by repairing or removing the unreadable content." The removed content is refereneced as "Removed records named range from /xl/workbook/xml..." I follow the path to the error, but it doesn't say what exactly its removing. I have referenced other sites and found that this seems to be an error with 03 reports brought into 07 environment and then instances or copy/paste are used in the reporting. i am just wondering if there is a solution that doesn't include rebuilding the entire report in 07

Hi all,

I've currently got a problem with the Excel 2007. i'll try to describe the problems as i found them.

Finance have 2 seperate instances of Excel open, they copy from one xlsx spreadsheet to another xlsx spreadsheet (seperate instances)
the first time they copy somehting it works fine
the second time they copy somehting it will coppy the cell structure, but the content will be empty

from this i thought it might have been a clipboard error, but the clipboard works perfectly well in most cases.

I asked around the office if this happened to anyone else, and it hasen't so i tried looking at why...
We've recently updated from office 2003 to office 2007 and finannce are one of the few sections that have updated their spreadhseets to Excel 2007, this isn't unique but they are the only ones that are copying from a converted excel document into another converted excel document.

After the user playign around for a bit he found out that it took maybe 20 copy / pastes between the 2 instances of Excel before one of them would corrupt.
When it corrupts it comes up with this message

Excel found unreadable content in 'MyExcelDocument.xlsx', Do you want to recover the contents of this workbook?
If you trust the source of this workbook, click Yes.

Clicking no will stop everything, clicking Yes will bring up a further error message box with

Repais to ''MyExcelDocument.xlsx'

Excel was able to open the file by repairing or removing the unreadable contnet.

Removed records: Style from /xl/styles.xml part (Styles)
Removed Records: Format from /xl/styles.xml part (Styles)

and as you can guess from the error message the spreadsheet is stripped of all the formatting finance have done on the spreadsheet, this is quit unacceptable for them as the formatting means as much as the data inside of it does... eg red is high priority, green is low priority ect.

I've foudn a work around by stretching a single instance of Excel between the 2 monitors and have the 2 documents open in one instance, but the ribbon bar stretches and goes between the 2 screens making ti quite difficult to use.

They have now gone back to using Excel format of 2003 that still works perfectly well even though this is now against company policy.

Can anybody suggest to me a way to fix this problem?

Thanks in advanced

Dave Henstock

OK, Excel 2007 allows more than 255 characters in a cell. However, if a URL of length greater than 255 is pasted into a cell, things start to go wrong.

The cell will appear to contain the full text, and will appear to be a valid hyperlink. However if I hover the cursor over the hyperlink, the address that appears has had the 'http:' portion replaced by 'file://', and the link doesn't do anything (afik).

If I edit the hyperlink, the address portion is blank and the 'text to display' portion contains the correct and full address starting with 'http:', so it appears that Excel is interpreting the long URL on the fly as something other than a http: address, for any URL over 255 characters.

If I copy the full and correct URL into the address field of the edit hyperlink panel and OK it, the cell gets stripped down to 255 characters and, naturally, doesn't work - it opens IE but doesn't go to the correct URL.

Strangely, I do have an Excel 2007 spreadsheet with URLs over 255 characters that work just fine, so something I've said above may not always be true. The speadsheet that works originated as Excel 2003, then became an Excel 2007 .xlsx file, and finally a .xlsm file. The one that causes the problems mentioned above started life as a .xlsm file.

So, does anyone know how to create a hyperlink to a long URL in Excel 2007, that works?

Thanks!

I have just installed Excel 2007 and wish to copy values from one worksheet (data downloaded from online banking in csv format) to the first blank row in another. I am manually copying a range of cells in the first worksheet and then, in the second worksheet, running a macro which includes the code:

Application.ScreenUpdating = False
rownum = 4
Cells(rownum, 1).Select
While Selection.Value ""
rownum = rownum + 1
Cells(rownum, 1).Select
Wend
ActiveSheet.Paste
. . . . and then various formatting functions

When I try to run the macro from a UserForm or by selecting it in the list of macros dialog box, it fails with the message

"Run Time Error 1004 - Paste method of Worksheet class failed"

The macro runs OK from a keyboard shortcut.

I get the same problem if I test it by using Record Macro to create a paste action and then run the recorded macro.

(Running Vista Home Premium)

Can anyone help please?

I am having problems with the following command where I am trying to copy then paste a range of cells from the worksheet "Labels" onto a Chart on the worksheet "Distance Chart", then the same picture onto the worksheet "Time Chart", and the worksheet "Error Chart".

In each case, I am first copying the same cells, then pasting them. The code is as follows:

Sheets("Labels").Range("A27:I33").CopyPicture Appearance:=xlScreen, Format:=xlPicture
Sheets("Distance Chart").Paste
Sheets("Labels").Range("A27:I33").CopyPicture Appearance:=xlScreen, Format:=xlPicture
Sheets("Time Chart").Paste
Sheets("Labels").Range("A27:I33").CopyPicture Appearance:=xlScreen, Format:=xlPicture
Sheets("Error Chart").Paste

This code is part of a larger code that does many calculations.

What I found is that if I first load Excel with this VBA code in it, the first time i run the file, it runs quickly. The second time, and every time after that it runs very slow.

I also discovered that if I eliminate this particular code from my larger VBA code, the speed is consistantly short - therefore this is the code that is causing the speed issue.

I have not noticed a problem using this code with Excel 2003 and Windows XP but have noticed a problem with Excel 2007 with Windows Vista - but I am not sure if this is the problem or not.

To see if this is a memory problem with Vista, I doubled the ram memory on my computer with Vista and it had no effect on the speed of this code.

Could the problem be related to clearing the clipboard and the amount of memory the clipboard needs?
Is there a more efficient way to copy then paste this information onto a chart?

I am having a problem with text boxes in Excel 2007.
When I copy text (in Arial font) and paste it in the same text box, it
appears as Calibri. I would like it to appear as Arial, just as it was when
I copied it.

I followed the directions for setting default font in new workbooks to
Arial, and I have this problem even in text boxes within new workbooks. I do
not have the problem outside of text boxes within new workbooks.

I also followed the directions for setting default text box style, and new
text boxes have Arial as their default font, as they should. However, when I
copy and paste within this new text box, the pasted text is in Calibri.

Please advise.

I seem to have run across a bug in Excel 2007 regarding conditional
formatting. If you insert a row in a table that has conditional formatting
rules applied, and then copy another row that also has conditional formatting
rules, Excel will add the new conditional formatting rules, rather than
replacing them. So, if you started with 3 conditional formatting rules, then
after the first iteration, you now have 6, then 9, then 12, etc. This quickly
gets out of hand and performance degrades quickly.

Here is the procedure for recreating the bug:

- Open a new Excel workbook in Office 2007
- Select cells A1:H1
- Apply formatting to the selected cells to put a border around the cells
(only did this so that I could see the cells I was working with)
- Apply conditional formatting rules to the cells
- If cell value is < 0, turn text blue
- If cell value is between 0 and 1, turn text green
- If cell value is greater than 1, turn text red
- Hit CTL-C to copy the cells
- Select cells A5:A6 and hit CTL-V to paste the cells to rows 5 and 6
- Select row 6 (entire row selected)
- Insert a new row
- Select row 1 (entire row selected) and hit CTL-C to copy the row
- Select A6 (this is the row you just inserted) and hit CTL-V to paste the
contents of row 1 into this row
- Select A6 (i.e. deselect the entire row)
- Review the conditional formatting rules for this cell. Note that the
number of conditional formatting rules has been doubled. Additional
conditional formatting rules will be added each time this procedure is
repeated.

I have an Excel application that uses a macro to automatically do this
because I want a specific row template applied when the user inserts a new
row. This template changes, based upon the type of data the user is intending
to insert.

Is there a way around this problem? Is there an option I can add to the
paste command that will replace the conditional formatting rules, rather than
adding additional rules?

Thanks,
John

I am experiencing problems after modifying spreadsheets in Excel 2007 (saving
as 2003 compatible .xls format). The files were last sucessfully worked on
in Excel 2003, but may have been created using earlier versions.

PROBLEM: Small files become huge, operations become slow and Excel is pretty
much unworkable.

I have read and tried most of the suggestions in earlier posts, which refer
to checking the last used cell and deleting unused rows and columns and site
information in link: http://www.contextures.on.ca/xlfaqApp.html#Unused.

Although, performing the unused cell deletion, does reduce the file size
marginally (from 6,132KB to 4,432KB), it doesn't solve the problem.

However, if I 'Copy & Paste' the used cell contents and formatting into a
new workbook, this works. File size is reduced to a tiny 146KB.

Does any one have know what could be causing this apparent file corruption,
and a possible fix?

I have a very large ( 400 MB) excel 2003 file broken into 18 tabs. I have
converted it to Excel 2007 (.xlsx). Each tab goes to column DD ( so about
108 columns) and they range from 20,000 - 60,000 rows. I am trying to
condense all the information on 1 worksheet in a 2007 format. The problem is
that whenever I try to copy the data, I get the error that the destination
size doesn't match the source size. I select the first cell (upper left hand
corner ) of where the cells should go, change over to the next tab, select
all the data, copy, switch back to the first tab, and try to paste in the
highlighted cell. This generates an error. How do I do this?

I have upgraded from Excel 2003 to Excel 2007 and am experiencing a
tremendous decrease in speed. The following speed comparisons were done on
the same machinewith the same file containing about 50 columnsx 5000 rows of
data and 7 charts of the data.

Time to select 4 charts:
Excel 2003: 4 seconds
Excel 2007: 57 seconds

Time to copy the 4 selected charts and paste them into Words 2007:
Excel 2003: 18 seconds
Excel 2007: 60 seconds

Finally, when saving the Word file in .doc format with the same graphs
pasted from the same excel file, here are the file sizes:
Graphs from Excel 2003: 187K
Graphs from Excel 2007: 235k

Is there any way to speed up Excel 2007? And why are the Word files larger?
This is a problem because we zip up a number of word files and send them via
email - the same files with graphs from Excel 2007 are now too large to send
in one email.

Thanks,
John

At an earlier posting I stated that my 120 Meg file with many macros and
formulas had dropped dramatically in speed with my new computer and Excel
2007. It was so slow that I could no longer use 2007 and was prepared to
return it. I had purchased an HP Intel 7200 duo with 4 meg and the latest
premium VISTA so I was obviously disappointed that my previous Dell with 1
Meg and single Intel 1.8? with Excel 2000 was far faster.
Solution to my problem: Apparently I had cut and pasted from my Banks
WebSite a banking summary. In that paste came a small icon representing a
bank check that you could click on and see a scanned copy of my personal
checks. Although I later tried to delete these icons from my spreadsheet, I
found that there were hundreds of copies of the same icon piled on top of
each other in the same cell. With Excel 2000 it ignored these icons but for
whatever reason, Excel 2007 recognized them and would consume all of my cpu
every time I made an entry, tried to filter data, inserted a line, etc. All
of my other sheets worked fine, it was just the one sheet with embedded
objects that created the problems. I don't know if this helps others but if
you're having problems like I was, look for any cut and pasted graphic
objects. I'm ectastic now with the speed and will keep my INTEL and
MicroSoft stock.
--
halfpint

Hello,

I have data files (1 per day) that are downloaded from a vendor site. The
files come accross with a WR1 extention. I beleive this is a Lotus Syphony
format.

The data length of each row is about 480 characters in the WR1 file.

When i import the data into excel 2007...it is truncating the data at 255
characters. I thought that cap on cell length was eliminated in 2007.

So I tried opening the file using MS Word. the full row was shown. I
copied and pasted the data from Word into excel and the full row with 480
characters shows up in the first cell.

That is the result i am looking for, but would love to have it happen in
just one step. I do not want to have to open in word and transfer to excel.

Once the data is in the single cell in Excel, i can easily parse the data
according to the record layout.

So any idea why i cant import the text or open the text file in Excel 2007
without truncating the data?

Many thanks for your suggestions.
PivotMan

I was having major speed issues with Excel 2007 on my PC (2.0Ghz Core 2 Duo,
2G RAM, XP Pro). Whenever I would save a .xlsx file down to an .xls file, or
try to work within some .xls files, EVERYTHING took a long time - cut/paste,
formatting, undo... it was ridiculous (and still is!). So, the secret? Open
up a brand new .xlsx file, copy the data from the .xls file (or slow .xlsx
file), and paste it in the new file. Presto! Things are much faster. Even
when I tried to save an .xls file as a .xlsx file, it was still slow, but
this fixed it.

Beware that if you try to save this as a .xls and work in that, it may slow
things down again.

ARE YOU LISTENING, MICROSOFT??

MS Net Framework is a real compatibility issue with Excel 2007 - causing
significant problems with the copy - paste function - one problem with excel
2007 circumvented, many many to go. Now quessing I'll have to run my net
framework apps on another computer

Hi,
I have two problems (bugs perhaps) that I need o find a way to work around
in Excel 2007. They both concern the category (x) axis (text) labels in line
charts. I normally shy away from line charts entirely but, in the given
instance I need to use them.

First question: when you first create the line chart, and when you set the
labels for the category axis, Excel automatically rotates the labels to get
them to fit as well as possible. However, if you go in to the Format Axis>
Alignment>Custom Angle box and enter a value, I can find no way of reenabling
Excels automatic selection of rotation. Even deleting the axis, and then
recreating it, does not reactivate this automatic feature. Previous version
of Excel had a radio button for "automatic" but I cannot find this in Excel
2007... Is there any way of reenabling the automatic rotation behaviour?

Second (more serious) question. I am using a line series with text category
axis to plot some time data for different years. As I am only using 3 months
for each year, I do not want to use a time series (most of the graph space is
then occupied by periods with no data). When I select my x axis label range,
everything is OK if this range is fully occupied: by selecting appropriate
entries for Format Axis>Axis Options>Interval between tick marks and
....>specify interval unit, I can get appropriately distributed ticks (each
representing, say, 1 week) and adequately spaced labels. However, I wanted
more control over the tick labels so I have created a further range with a
formula which results in a blank unless the original label is for the first
or 15th of a month at (near) midnight. So far so good, but when I make the
line chart refer to this range, which is predominantly blank (""), the chart
now shows only the first label or, by playing with the ...>specify interval
unit setting, I can perhaps get it to show the first two tick labels but
under no circumstances all of them (there are about 30 in total, fairly
evenly distributed along the range but corresponding to useful dates). In
previous versions of Excel (I have just tried to make sure that this is the
case), it would work well once this new range is selected and the tick label
spacing set to 1 but not in Excel 2007... I have even tried copying the range
with the formulae to a new range and pasting it as values only (no
difference) and even going in and deleting all the blank cells in the range
between consecutive labels but nothing changes...

Is this behaviour common and is there a work around???

Any help very gratefully received as I have sort of hit a brick wall with
this and, other than going back to Excel 2003m which I would for various
reasons be loathed to do, cannot think of anything else to try...

Many thanks and best wishes, Boris.

Hello,

I have read a lot of posts regarding copying Excel charts into Word, and
have definitely picked up some good tips. Unfortunately, none of them have
helped with this problem.

I have a user who has multiple charts embedded on a spreadsheet. When he
tries to copy one of them into a Word document, the chart only includes two
of the data series - there are a total of six. The "keys" in the legend for
the other four series appear, but with no data attached. Only two data
markers appear on the chart. He used the same file to copy and paste the same
charts before we migrated to Vista and Office 2007 without any problem. The
charts always pasted completely.

I have gone through every way of copying and pasting - using all the options
under Paste Special:
Excel Object
Picture (Windows Metafile)
Bitmap
Picture (Enhanced metafile)
Picture (GIF)
Picture (PNG)
Picture (JPEG)
MS Office Graphic Object

I tried to use the "Copy as picture" option through Excel, using both "As
shown on screen" and "As shown when printed" - always with the same results,
incomplete data being represented.

The only solution I have found is to do a print screen, or use the Snipping
Tool.

Another strange thing is when i tried to copy and paste it back into Excel,
just to experiment, the same thing happened - the pasted chart only included
two data series.

This is not a situation where the user can embed the charts on separate
worksheets, they must stay together for the report.

I am totally confused by this one. Any suggestions as to why this is
happening?

Thanks!

When I copy selected cels from the source workbook to the destination
workbook using Paste Link the operation appears to work fine, however it also
renames all of the tabs in the source workbook to Chart 1, Chart 2, etc.
forcing me to change them again. I also noticed that if I opened the
destination workbook first it would rename the tabs if I then opened the
source workbook. This is a problem because I am trying to condense data from
10 workbooks with about 20 worksheets.

Is anyone else having this problem? Is there a known fix? I have tried
every day to get the latest updates to Office EXCEL 2007 but so far there
aren't any.

When emails are sent from Excel using outlook the source formating does not
transfer through to the email when the excel sheet is sent in the message
body. Columns become oversized and flow off the page.

We did not have this problem with office 2003. We could email excel sheets
with outlook and the formating was exactly like it is in excel. I have made
sure the settings are all set to keep the source formating but it does not. A
copy & paste from excel to outlook 2007 also loses its formating.

Any solutions?

I have a problem with the new Excel TR2. I have an extensive file that I
update frequently. Some of the formulas in the cells are quite complex. When
I want to do some new stuff, I usually select a column of cells and the next
column to the right, and then hit ctrl-r to copy right.

In the past with Office 2007, this has worked just as I expected; i.e.
formulas in the cell are automatcially incremented in the news column. E.g.,
if one cell has the formulat "=G1" and I copy right, the new cell one row of
has "=H1".

Now it Excel doesn't do make the change from G column to H column in the new
cell that I ctrl-r on (cut and paste also don't work). Althought it's more
weird than than. Currenlty I have about 50 rows. If I select the last cell
in row 1 and the next empty cell to the right, and then hit crtl-r, in my
current case the old row has "data!GM1" and the new cell does update to
"data!GN1." But IF I drag and select all 50 rows in the last column and the
next empty column and ctrl-r, this new cell has "data!GM1," as does the rest
of the rows.

How do I fix this? Is this a bug or a setting?

Thanks!

My excel 2007 on Windows 7 operating system on my "JOb computer" seems to have a probelm with regular cut function.
When I highlight cells I want to cut and press cut (either on keyboard shortcut Ctrl+x, Home menu cut command, or from the right-click menu) cells start flashing for a split second and after that they only turn normal as if cut was not active. When I want to paste them, they paste as if copy function was used. If I try to rightclick destination cell to use function "insert cut cells" it is not one of the offered options at all.

Does someone have similar problem or knows the solution?

On my home computer I have same combination, Excel 2007 on windows 7 and it works just fine. But my home OS is 32-bit Win7, and on job comp it is 64-bit version. Could this have caused the problem?


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