Free Microsoft Excel 2013 Quick Reference

Error message when copying Excel Pie Chart to Word (in Office 2007

I am getting an error and Excel is shutting down when I try to copy/ paste
special (as a bitmap, or windows metafile, or picture, etc) a pie chart using
colored data labels for each part of the chart. If I turn off these label by
color boxes and just use a plain label or a lable with a line, the copy/paste
special works fine. These pie charts were created in Excel 2003 and then the
file was converted to Excel 2007 format. The Word version that I am using is
2007, but the file is still in compatibility mode with a 2003 word file. (I
also tried this using 2007 to 2007 type files and it gave me the same
(unreadable content) error and then it shut Excel down).

Does anyone have any ideas of what might be causing this or how to work
around it.


Error Messages When Editing, Running, or Recording VBA Macros in Office 97 Application on Windows 2000

I installed Adobe Acrobate 6.0 on our computer and now I get the following
error message when opening Excel. I posted this to the Adobe Acrobate
newsgroup with no answer so I thought that I would try this newsgroup and
maybe you can aim me in the right direction.

I get the following error message when opening Excel.
Microsoft Visual basic
Class not registered looking for object with
CLSID{AC9F2F90-E877-11CE-9F68-00AA00574A4F)
When I click on the OK button twice the error message leaves and my Excel
document will open. I have removed Adobe Acrobat 6.0 and then started my
Excel and I do not get the error message but when I re-install Adobe Acrobat
6.0 the error returns. I have run the detect and repair on both Adobe and
my Microsoft office program. I am using Microsoft office 2000. The error
message only show up in Excel when I open it.
Would appreciate any help I can get to try and solve this.
Lem

Gridlines print AFTER .docx saved - Excel linked to Word (MS Office 2007)

Scenario:
created Word 2007 document (.docx) with linked Excel object from Excel 2007 (.xlsx) via:
Excel: copy selected range [Excel GRIDLINES CHECKMARKED to print in VIEW tab];
Word: paste, paste special, paste link/Excel 2007 object).
After linking, saved file & printed.  Gridlines DID NOT print - which is what I wanted.
No other changes made; closed document; closed Word.

THE PROBLEM:
Later, opened Word, opened the same .docx document w/ linked Excel object;
have answered both YES and NO to '...update link...?' (same result below with both answers);
No changes made to document
Printed the document - GRIDLINES PRINT! (not the same as when initially created & not what I wanted).

QUESTION:
Why does it print fine initially (no gridlines) but after saving & closing Word then re-opening it PRINTS THE GRIDLINES?

I do not experience this problem if I'm using .doc and .xls files.  Any assistance would be appreciated.

 

Hi This is my first post, I have a little bit problem in my old macro which is may be from 97
the function work as it should but the result came for just the first cell which it should be 5 cells the code for the macro is
------------------------------------------------------------------------------------------------------------------------
 Function reflect(depthprev, depth, sonic, rhob, acimprev, ctprev)
 '***************************************************************
  Dim vb, acim, tint, ct, yanki As Single
  Dim petc(1 To 5) As Single

  vb = (1 / sonic) * 1000000
  acim = rhob * vb
  tint = (depth - depthprev) / vb
  ct = ctprev + tint
  yanki = (acim - acimprev) / (acim + acimprev)
  petc(1) = vb
  petc(2) = acim
  petc(3) = tint
  petc(4) = yanki
  petc(5) = ct
  reflect = petc
End Function
--------------------------------------------------------------------------------------------------------------------

I hope someone who know how to fix this to run in office 2007 because I don't know VB

We recently upgraded to Windows XP client with MS Office 2003. We noticed
an error message when saving Excel files. The files were created under
Office 2000 on Windows 2000 work stations. The message when saving the file
file after modifications is: "The file ( filename .xls) may have been
changed by another user since you last used it. In that case what do you
want to do? Save a copy ? Overwrite changes."

Has anyone seen this behavior? How do we make it stop?

Vanessa Graham
University of Baltimore

On some excel spreadsheets, I get an error message as a result of trying to copy a sheet.
I get a Microsoft Excel error box that says:

"A formula or sheet you want to move or copy contains the name 'Conflict', which already exists on the destination
worksheet.
Do you want to use this version of the name?
- To use the name as defined in the destination sheet, click Yes.
- To rename the range referred to in the formula or worksheet, click No, and enter a new name in the Name Conflict dialog box."

The Error Box allows me to click either
Yes or No.

If I click Yes, I get the
another (same) dialog box for the next name 'conflict1', then another, etc.

I have to click yes many many times (for each of the mysterious phantom names that supposedly 'already exist' ) before finally getting the sheet copied.

The weird thing is that I don't use this name in this worksheet, nor do i know where it came from or where it is located in the file.

The Insert/Name/Define process does not report any of these phantom names; and the View/Report Manager also does not list any Reports with such names.

This is an extremely annoying occurance
and i suspect it is as a result of sheets that may have been copied or moved, a long time ago, from another file.

Any ideas how to eliminate this annoying bug?

I am working on a Powerpoint 2003 slide with an Excel pie chart embeded in
it. One of the titles (the word "convection") breaks between the "o" and "n"
in "tion". I can't seem to be able to adjust the space allotted. How can I
correct this? --

Sweetsweed

I have an excel workbook that gets updated daily and now is no longer saving
changes. I get an error message that says Excel could not save all the data
and formatting recently added to and then lists my file name. I've doing
save as new name, but still not able to save this document. any suggetions
on how I can correct this will be appreciated.

Hi,

I'm hoping someone can help here the code below is part of a large project/workbook that has been used over the last 12 months as part of an order process without hitch. however on Friday it just stopped working.

Application.ScreenUpdating = False
    
Set Pcontract = Sheet12.Range("L3")
FileName = Sheets("Contract Generator").CompanyName.text
Name = Sheets("contract Generator").Username.text

Select Case Telephony

    Case False
    Sheets(Array("CPC", Contract, "DD", "CC")).Copy
    Set WB = ActiveWorkbook

    Case True

    Sheets(Array("CPC", Contract, "Telephony Site Details", "DD", "CC")).Copy
    Set WB = ActiveWorkbook

End Select

filename1 = "SHEFFIELD-1DataBus339-BusContactCentreSalesPrivateContracts" & Name & "" &
FileName & " " & "-" & " " & OrderType & ".xls"

If FileFolderExists(filename1) Then

        TheFile = Application.GetSaveAsFilename("SHEFFIELD-1DataBus339-BusContactCentreSalesPrivateContracts" &
Name & "", _
        "Workbook (*.xls), *.xls", , "Contract Exists:")
    
        If TheFile = "False" Then
        
               MsgBox "You cancelled"
               Exit Function
               
        Else
        
               ActiveWorkbook.SaveCopyAs FileName:=TheFile
               
        End If

Else: WB.SaveAs FileName:="SHEFFIELD-1DataBus339-BusContactCentreSalesPrivateContracts" & Name &
"" & FileName & " " & "-" & " " & OrderType &
".xls"

End If
    
    ActiveWindow.Close

    Select Case Telephony

    Case False
    Sheets(Array("CPC", Contract, "DD")).PrintOut

    Case True

    Sheets(Array("CPC", Contract, "Telephony Site Details", "DD")).PrintOut

    End Select


The error occurs on this line -


The second workbook is created, as I can see it in the taskbar. If I click end to clear the error message - (Method 'Copy' of the object 'Sheets' has failed -2147417848 (80010108)) , VBA still works but the workbooks hang and I have to Force close. On occaisions the workbook is then corrupted and Autorecover attempts to restore it without much success.

This occurs on all users machines

Any ideas are very welcome

Hi,
I have one macro which runs in Excel 2003 but dosent run in Office 2007.
This macro also runs in compatibility mode excel but dosent work in 2007
macro enable excel. Please find below is the code. Is there any reference
which we need to setup.

This macro is to get the data from database.

Please find below is the code and where I am getting the error. Error I am
getting is "Runtime error 424, Object required". Please help me in this.

Sub Get()
Dim i1 As Integer
Dim str1 As String
i1 = 2
While [querylist].Cells(i1, 1) "" --This is the place where I am
getting error in Excel 2007
CreateQuery (i1)
i1 = i1 + 1
Wend

Worksheets("Sheet1").Select
ActiveWorkbook.Save
End Sub

Thanks,
Mahesh

Periodically, I need to extract data from one of my email inboxes. To
do so, I open Excel. From that, I open the desired inbox from my email
program. Excel opens it just like it would any other text file -
sometimes.

Here's my question. The process works flawlessly from my laptop which
has Excel 2000 v.9.

However, from my desktop, which has the same email program version, but
a newer version of Excel (Excel 2002 10.xxx SP-1), it doesn't work. I
copied the inbox file that opens fine on my laptop to my desktop. When
I try to open it from my desktop (with the newer version of Excel), I
always get an error message which says, "(Name of file) is not a valid
Web Archive."

I don't know what Web Archives have to do with any of this and all of
the available Excel converters which come with Microsoft Office have
been installed on the machine.

Any idea how I can get Excel 2002 to stop creating these error messages
and actually open the file?

Thanks

--
orutulsa
------------------------------------------------------------------------
orutulsa's Profile: http://www.excelforum.com/member.php...o&userid=32454
View this thread: http://www.excelforum.com/showthread...hreadid=522277

Periodically, I need to extract data from one of my email inboxes. To do so, I open Excel. From that, I open the desired inbox from my email program. Excel opens it just like it would any other text file - sometimes.

Here's my question. The process works flawlessly from my laptop which has Excel 2000 v.9.

However, from my desktop, which has the same email program version, but a newer version of Excel (Excel 2002 10.xxx SP-1), it doesn't work. I copied the inbox file that opens fine on my laptop to my desktop. When I try to open it from my desktop (with the newer version of Excel), I always get an error message which says, "(Name of file) is not a valid Web Archive."

I don't know what Web Archives have to do with any of this and all of the available Excel converters which come with Microsoft Office have been installed on the machine.

Any idea how I can get Excel 2002 to stop creating these error messages and actually open the file?

Thanks

Hi,

I am get an "Unable to read file" error message when opening a Excel
file that contains a PivotTable report.
All the symptoms match microsoft support article 819853, except I am
using Office 2003 not 2002.
Is there a patch for the problem and how do I obtain it.

I do need to unprotect and protect the workbook and worksheets, and
not corrupt the file.

Regards
Tim

Hi,

I am get an "Unable to read file" error message when opening a Excel
file that contains a PivotTable report.
All the symptoms match microsoft support article 819853, except I am
using Office 2003 not 2002.
Is there a patch for the problem and how do I obtain it.

I do need to unprotect and protect the workbook and worksheets, and
not corrupt the file.

Regards
Tim

Firstly, thank you for reading this. I am very much a VBA newbie, so any help is greatly appreciated.

I have a workbook ("Scorecard_working template.xls") with sheets "Open Items" and "Closed Observations" and a macro code on Excel 2003.

The macros run just fine on the computer it were written on, but when I try to run them on the workbook from another computer (runs Excel 2003 also), I get the error message "Method 'Copy' of object 'Range' failed" on the Excel screen and the message "The object invoked has disconnected from its clients" on the VBA screen; Excel also seems to freeze up, and I can't select cells. Is there something I can fix to get the macros to run correctly on other computers?

The first macro is intended to move a row from "Open Items" to "Closed Observations" when a row is marked "Closed" in Column R:


	VB:
	
 tester() 
    Dim rng As Range, usedcell As Range 
    Dim lastrow As Long, x As Boolean 
     
    Set rng = Intersect(Sheets("Open Items Track List").UsedRange, _ 
    Sheets("Open Items Track List").Range("R:R")) 
     
    For Each usedcell In rng 
        x = Evaluate("=NOT(ISERROR(SEARCH(""Closed""," & usedcell.Address & ",1)))") 
        If x Then 
            lastrow = Sheets("Closed Observations").Cells(Rows.Count, "R").End(xlUp).Row 
             'This is where the debugger highlights the error
            Sheets("Open Items Track List").Rows(usedcell.Row).Copy Sheets("Closed Observations").Rows(lastrow + 1) 
            Sheets("Open Items Track List").Rows(usedcell.Row).ClearContents 
        End If 
    Next usedcell 
     
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
The second macro is intended to move a row from "Closed Observations" to "Open Items" when a row is marked "Open" in Column W:


	VB:
	
 x () 
    Dim rng As Range 
     
    Set rng = Intersect(Sheets(“Closed Observations”).UsedRange, _ 
    Sheets(“Closed Observations”).Columns (“W”)) 
     
    For Each rng In Columns (“W”).SpecialCells(x1CellTypeConstants).Areas 
        Select Case rng(1) 
        Case “Open” 
            Rows(rng(1).Row).Cut Sheets(“Open Items Track List”).Rows(Count + 1).Offset(1,0) 
             
        End Select 
    Next rng 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Your help is very much appreciated, thank you in advance!

I have an Microsoft Office 2001 Excel file with multiple sheets and charts, running on a G3 Macintosh, using OS 9.2. I am using around 30 macros so users can navigate to charts easily. The file has been working fine, except lately, occasional opening of the file results in the following error message:
"File Error: data may have been lost"
I reverted to an error-free backup, and recreated some things I lost- but now this copy occasionaly gets the error message.
Any thoughts on this??
(I have re-installed Office once- I have also opened the file on a nother computer- and it gets the error message).
The file does eventually open up, but there seems to be some error in a couple of macros.

I have been getting an error message that reads "08E38100: file format is not
valid" when I open Excel. Once I click OK, everything seems to work fine as
far as I can tell though process time seems a little slow. Once I have Excel
opened for the day, I can open other spreadsheets without getting this
message. It is only on the initial opening of Excel. Would anyone know how
to fix this so I don't get this error message?
Thank you
--
Constance

Excel 2000 SP 1
When every record does not have content in the last column of the excel
spreadsheet - it produces the "too few data fields in record 16" error
message.

This is a recurring error in Excel upgrades -- some upgrades anticipate the
fact that there may/may not be data in the last field. Others, like Excel
2000 SP1 do not.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I have recently encountered a problem when trying to save a file each time I edit it. I receive the error message "excel could not save all the data and formatting you recently added to the file". I then have the option of saving the file without repairing the problem, to go to the help page, or to cancel. If I save the file without repairing the problem and then open it up again, the file appears to be fine. If I go to "help" I just see a blank page. I am not sure if I can trust the saved file given the error message. The editing I am doing to the file generally has quite a bit of copying and pasting between cells and sometimes the file saves without an error and sometimes not and it seems to depend on the order I copy and paste various cells. If I use "paste special" it seems to be the "validation" copying that causes most errors. I have also found this error when I simply deleted a column from one version of the file. Does anyone know what this error message actually means please and how to solve the problem?

Excel 2000 SP 1
When every record does not have content in the last column of the excel
spreadsheet - it produces the "too few data fields in record 16" error
message.

This is a recurring error in Excel upgrades -- some upgrades anticipate the
fact that there may/may not be data in the last field. Others, like Excel
2000 SP1 do not.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Hi. I am wondering if it is at all possible (and if so, how) to CREATE your own error message (sorry about spelling mistake in heading =P) in Microsoft Excel.
Thanks in advance.

First off, sorry if the title is bad. The problem i am having was hard for me to describe.

But anyway here it goes. Please look at attached file so i can describe my problem much easier. I am using excel 07 on vista. fyi.

Ok when you open up the file please ignore everything above the blue bar. That was the old data which was arranged wrong. I have actually figured a lot of this out but i am stuck. The graph is set up so when you click on the drop down menu (F26) it changes the graph to the relevant data. Now the bottom graph is currently graphing the Months Expense1 as a total of all Expense1. So January Expense1 was $100 so its 26% of all Expense1. and when you click on the drop down button you can changed the data to Expense2 and the graph changes. YAY ok thats cool. However, thats not what i want. I want the pie chart to be graphing the expenses as a percentage of total Expenses. So the drop down menu would be of the months instead of the expenses.

I have changed that with relative ease, but I cant get the data to graph how i want it to.

I have been using OFFSET() formula and the define name manager to set up the previous graph. You can easily look at the formulas i have used instead of me trying to explain everything. Please help. This is the test bed for a budgeting spread sheet I am working on.

if you can help me out that would be great.. Please try not to use Macros because i dont understand them all that well and I need to take what is done in this spreadsheet and learn from it and change it so it works when are thre 10 expenses.

Thanks
Chris

Other relevant data.
Expense drop down button is named New using the Name manager.. and the formula used is shown directly above it. I assume that this formula is what needs changing.

Hope someone can help me with this problem. I'm currently teaching
class in Excel 2002 and we are working on macros.

Here's the problem:

After inserting the macros into the workbook and running it I come u
with this error message:

Macros in this workbook are disabled because the security level i
high, and the macros have not been digitally signed or verified a
safe. To run the macros, you can either have them signed or change you
security level.

Ok, so I go into *Tools* , *Options* , and *Security* , *Macr
Security* . I change the security from high to low and hit ok. I stil
get the same error message.
Next I try to fix the digital signature, I use _Selfcert.exe_ an
_Makecert.exe_ to create a digital signature for the macros. Hav
creating the certificate and sign it to the macro, I try to run i
again but I still get the same error message.
I then used Registry Editor to create a XLM key for excel, but stil
getting the error.

I'm not sure what to do next, I hope someone can help me befor
Monday.

(BTW - I don't know if this has anything to do with the curren
problem, but I have _Deep_Freeze__ program on the computer. But it i
disabled.

--
Message posted from http://www.ExcelForum.com

I get an error message when I try to manipulate a very large Pivot Table. The
message says "Excel cannot make this change because there are too many row or
column items. Drag at least one row or column field off the PivotTable or to
the page position. Alternatively, right click a field and then click Hide or
Hide levels on the shortcut menu."

I can't even figure out how to execute the remedies in the error message! I
can manipulate other Pivot Tables from other ss just fine. And my colleagues
have no trouble with this particular very large Pivot Table--just me. Is
this a capacity issue with my computer? Hard disk size?