Over 1 million tech questions and answers.

Microsoft.Office.interop.Excel reference is not working in asp.net published project

Q: Microsoft.Office.interop.Excel reference is not working in asp.net published project

References with dll are published. But only Microsoft.Office.interop.Excel and Microsoft.Office.interop.Access is not working.
I got error like,
System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception
from HRESULT: 0x80070005 (E_ACCESSDENIED)). at System.Runtime.Remoting.RemotingServices.AllocateUninitializedObject(RuntimeType objectType) at System.Runtime.Remoting.Activation.ActivationServices.CreateInstance(RuntimeType serverType) at System.Runtime.Remoting.Activation.ActivationServices.IsCurrentContextOK(RuntimeType
serverType, Object[] props, Boolean bNewObj) at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) at System.RuntimeType.CreateInstanceSlow(Boolean
publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark) at System.Activator.CreateInstance(Type type, Boolean nonPublic) at System.Activator.CreateInstance(Type type) at Project1.WebForm1.READExcel(String path)

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Microsoft.Office.interop.Excel reference is not working in asp.net published project

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

RELEVANCY SCORE 75.2

Hello everybody,

One of our clients is facing this issue in excel as showing below, what came in my mind is to reinstall office.

But, i would like to know if there is alternative and correct method to solve.

Thank you.

A:Microsoft Office Excel has stopped working

You could try to repair. If that doesn't help there are also links to uninstall.

Repair Office programs - Project - Office.com

Read other 4 answers
RELEVANCY SCORE 75.2

I have installed Office 2003 on a Windows 7 Professional laptop. Excel intermittantly crashes with error message 'Microsoft Office Excel has stopped working'. The error occurs while doing various things, such as copy & paste, closing Excel, running macros etc.
Following advice from other forums I've tried

Repairing Excel.
Reinstalling Excel.
Disabling Bluetooth.
Setting BtOfficeAddin.BtOfficeIntegration data entry in the registry to 0x00000000 (0).
The macros worked fine on XP but I keep getting this error on Windows 7. Does anyone have any advice?
 

Read other answers
RELEVANCY SCORE 72

I'm hoping someone can help me with a small project I have.

Essentially, I want to create a spreadsheet using Microsoft Office Excel 2010 that would act as a time-sheet. It would have two columns - the first being a start time and the second being an end time.

So, a cell in the first column might say 8:30am, while a cell in the second column might say 5:30pm. What formula or method do I need to use to have a cell in the third column automatically tell me how many hours were spent in that time (9)?

Any help would be greatly appreciated.
 

A:Solved: Working Out Hours Between Start And End Time In Microsoft Office Excel 2010

Read other 14 answers
RELEVANCY SCORE 70.4

Microsoft Office Project is the name of a program that helps with a variety of Projects

A friend bought a laptop in Spain - most programs are in english

Project seems to be in Spanish

I have never heard of this program - is it part of the Office suite, as I can't find it on my computer.

How would he obtain an english version as he wants to use the Home Construction Template he downloaded from the Office Site

Thanks
 

A:Microsoft Office Project 2003 Query

bump
 

Read other 3 answers
RELEVANCY SCORE 69.2

Hiya

To make Microsoft® Office® XP applications available to Microsoft Visual Studio® .NET developers, Microsoft has created several primary interop assemblies (PIAs) that contain the official description of commonly-used Microsoft Office XP type libaries for applications such as Microsoft Access 2002, Microsoft Excel 2002, Microsoft FrontPage® 2002, and so on. This group of PIAs is known as the Office XP Primary Interop Assemblies.

Microsoft has customized the Office XP PIAs to make them easier for managed code to interoperate with the Office XP COM type libraries. Avoid using any Office XP COM interop assembly that is not provided as part of the Office XP PIAs, or any Office XP COM interop assembly that is generated by Microsoft Visual Studio .NET at design time because they are considered unofficial.
System Requirements
Supported Operating Systems: Windows XP

Minimum system requirements for the Office XP Primary Interop Assemblies (besides Microsoft Office XP) include Microsoft Visual Studio .NET for solution developers, or the Microsoft .NET Framework Redistributable for end users. For more information on these products, including additional system requirements, go to the Microsoft Developer Network (MSDN) Web site at http://msdn.microsoft.com/vstudio or http://msdn.microsoft.com/net.

http://www.microsoft.com/downloads/...1e-3060-4f71-a6b4-01feba508e52&DisplayLang=en

Regards

eddie
 

Read other answers
RELEVANCY SCORE 68.8

Hiya

Microsoft Office Project Server 2003 uses the Project Server Tracing Service to log application errors to the Event Viewer. The Project Server SetTracing Utility also allows you to redirect the tracing output to a log file, or to the Event Viewer and a log file. Directing application errors to a log file will output the errors to a format that you can send to Microsoft Product Support Services, making it easier for them to help determine the cause or causes of any errors your organization may be running into.

System Requirements
Supported Operating Systems: Windows 2000 Service Pack 3, Windows Server 2003

This download works with the following Office applications:

Microsoft Office Project Server 2003
http://www.microsoft.com/downloads/...62-0c72-4fa6-9cdf-6a796bde2882&DisplayLang=en

Regards

eddie
 

Read other answers
RELEVANCY SCORE 67.2

Hi all,

I am trying to get a complex formula to work - it references an external file using a concatenated filename and the INDIRECT fuction.

Here is the formula I'm using (forgive me now!) - this gives me a #VALUE! error

Code:
=INDIRECT((CONCATENATE("=SUMIFS(",M$2,"!$R:$R,",M$2,"!$O:$O,",CHAR(34),"CCOR0401",CHAR(34),",",M$2,"!$D:$D,$D6) + SUMIFS(",M$2,"!$R:$R,",M$2,"!$O:$O,",CHAR(34),"BCB60033",CHAR(34),",",M$2,"!$D:$D,$D6)")), FALSE)
I know that the CONCATENATE function gives me the following result:

Code:
'=SUMIFS('[IT Costs 2011-01.xls]TRS Jan 2011'!$R:$R,'[IT Costs 2011-01.xls]TRS Jan 2011'!$O:$O,"CCOR0401",'[IT Costs 2011-01.xls]TRS Jan 2011'!$D:$D,$D6) + SUMIFS('[IT Costs 2011-01.xls]TRS Jan 2011'!$R:$R,'[IT Costs 2011-01.xls]TRS Jan 2011'!$O:$O,"BCB60033",'[IT Costs 2011-01.xls]TRS Jan 2011'!$D:$D,$D6)
And I know that formula is correct because when I copy the value and remove the leading apostrophe I get the result I expect. Yes I have the referred file open while I am doing this.

So from the above it seems as though everything is working up until I wrap my CONCATENATE formula in the INDIRECT fuction. What is going wrong?

Thanks in advance,

Jess
 

A:Excel external file reference using INDIRECT not working

I got it!!
Code:
=SUMIFS((INDIRECT(M$2&"!$R:$R")),(INDIRECT(M$2&"!$O:$O")),"CCOR0401",(INDIRECT(M$2&"!$D:$D")),D6) + SUMIFS((INDIRECT(M$2&"!$R:$R")),(INDIRECT(M$2&"!$O:$O")),"BCB60033",(INDIRECT(M$2&"!$D:$D")),D6)
I didn't realise I couldn't use the whole formula in the INDIRECT function. Once I updated it to use INDIRECT only for the file reference sections of the formula I was fine. Whew!
 

Read other 1 answers
RELEVANCY SCORE 65.6

In Word 2013 I am hooked on event DocumentBeforeSave. When user wants to save document, backstage view is displayed with possible locations and also recent folders. After user selected one of recent folders, event DocumentBeforeSave is triggered. Where is the information about selected path stored? I need to display Save dialog(Dialogs[WdWordDialog.wdDialogFileSaveAs]) directly in this event, but first I need to know which path user selected. Otherwise default path is selected and it could be counfusing for the user.

Read other answers
RELEVANCY SCORE 65.6

Hi,

Sorry for posting a Edge question here, because I cannot find a Edge forum.

My company has a web recorder tool that works on IE11, this recorder works by utilizing Interop.SHDocVw.dll and Microsoft.mshtml.dll for capturing HTML events and parsing DOM content.

My goal is to add support for Edge browser to this web recorder tool. My questions are:
1. Does Edge browser support Interop.SHDocVw.dll and Microsoft.mshtml.dll for backward-compatibility on IE11? 
2. Does Edge browser have corresponding DLLs that could be used to capture HTML events and parse DOM?

Do you have any suggestions on how we might support Edge browser in our web recorder tool?


Thanks a lot.

Read other answers
RELEVANCY SCORE 64.4

I'm using the Windows XP operating system and had Microsoft Office installed on it a while ago. All the applications were working fine when I first got it. Yesterday, when I tried to open Microsoft Excel I get the message that 'the feature you are trying to use is on a CD-ROM or other removable disk that is not available', and it asks me to insert the 'Microsoft Office 2000 Premium' disk and click ok. Unfortunately, I don't have this disk because it was someone else that installed Office on my computer for me. I don't understand why it's not letting me use Microsoft Excel and why I get this message from Windows Installer every time I try to use the application.

It was working fine not long ago and I've used it to make several spreadsheet files, all of a sudden for no apparent reason I'm getting this message every time I try to use it.

Can anyone give me any advice and has anyone had a similiar problem? I would appreciate any help.
 

A:Microsoft Excel help, keeps asking for 'Microsoft Office 2000 Premium' disk

When it was installed, some aspects will be "installed on first use", and now it wants to install the function, for which you need the CD.

You really cannot use it successfully (not to mention legally) if you do not own and have the disks.
 

Read other 1 answers
RELEVANCY SCORE 60.4

The Microsoft Advanced Threat Analytics Management Pack published Oct 3, 2017 isn't for ATA 1.9.  I can't find an MP for 1.9.  Is one even out yet?  If so, where can I find it that search algorithms cannot?  If not, when will it be available?
Sincerely, 

"I need that management pack."

Read other answers
RELEVANCY SCORE 60.4

Hi People,

I have the MS Office Excel 2003 installed on my PC. Last week I deleted a file and now I have to recover/recuperate it. Do anybody know how I have to proceed to recover a deleted file on my PC? Thanks.

A:Microsoft Office Excel 2003 - Help!

Stupid question, but did you check the recycle bin?Check out some of these programs, though I know nothing about how effective they are:http://www.download.com/3120-20_4-0.html?q...lete&tg=dl-2001

Read other 3 answers
RELEVANCY SCORE 60.4

US-Cert has issued an alert to remind users of MS Office and MS Works to install the critical Microsoft update released today that addresses vulnerabilities that could allow an attacker to take control of your computer.See :MS06-012 - Vulnerabilities in Microsoft Office Could Allow Remote Code Execution (905413) (March 14, 2006) athttp://www.microsoft.com/technet/security/...n/ms06-mar.mspxRegards,John

Read other answers
RELEVANCY SCORE 60.4

I have MS Office Premium. In Excel, is there is a way to hide tabs in a workbook?
 

A:Microsoft Office Premium-Excel

If thats office 2000 click on the tab to the worksheet you want to hide, then click the Format menu==>sheet==>hide.
 

Read other 3 answers
RELEVANCY SCORE 60.4

My desktop pc is a Compaq Presario with Windows 95 and Microsoft Office. Recently it has started taking forever to close down a Word document or an Excel spreadsheet. The program itself closes out in normal speed but its the separate documents that take forever.

I have checked disk space - plenty available. I have done the usual maintenance ie defragmentation, scan disk etc.

Any suggestions? Thanks in advance.

Diane
 

A:Microsoft Office-Word and Excel

If you're using office 97, according to microsoft, one possibility is that outlook is journalizing your other office documents. They say to start outlook and under tools / options / journal clear all the check boxes under 'also record files from' list. They say this can cause files to close slowly even if outlook isn't running.

 

Read other 2 answers
RELEVANCY SCORE 60.4

When I open Excel 2003 the splash screen hangs for 30 seconds to about a minute and then excel opens and behaves normally.
All other office programs such as Word etc open quickly and behave normally.
If Excel is opened in safe mode , the program opens rapidly without any splash screen at all.

Any explanations and indeed a cure for this behaviour ?

Regards

Flynne
 

A:Microsoft Office XP Excel 2003

Read other 11 answers
RELEVANCY SCORE 60.4

I'm using Windows XP, Microsoft Office 2007 Professional. When I highlight a column, the highlighted color is so light that when I do a "Find" (Control F) command and it finds the value you can't tell it found the value. (The found value is in white which isn't much different than the highlighted column.) Is there any way I can darken the highlighted column? I've tried changing the color scheme for the entire program and that doesn't help.
 

A:Microsoft Office 2007 Excel

Read other 8 answers
RELEVANCY SCORE 60.4

Dear Sir/Madam,
This is with respect to our excel problem.We get the error "excel cannot complete this task with available resources.choose less data or close other applications".
For ur information we are using Windows XP, Microsoft office 2003.

Pls let us know the solution.

Regards,
Sharash
 

A:Microsoft office excel problem.

Can you give more information to help diagnose the problem?

The error you are encountering is many times associated with a calculation that involves many cells at one time and the computer may not have enough RAM to complete the calculation. possible solutions (without knowing more about the problem) include,

1. Reduce the amount of cells to be calculated at one time.

2. check to see if the calculation formula or function is correct (sometimes a mistake in the formula or function itself may cause the computer to go into a "loop")

3. Install more RAM to accommodate the needs of the spreadsheet.

Let me know more info on the problem
Robert
 

Read other 1 answers
RELEVANCY SCORE 59.6

Dear friends,i have uninstall the excel from my new hp laptop unfortunately,please suggest me to how can i get back that.that software is builtin.

Read other answers
RELEVANCY SCORE 59.6

Well not really a problem with Excel, more of a memory problem with me. A few years back (in '03 Office) I collapsed the Excel file by way of a phone conversation. And now I forget nor find the way to un-collapse and get my lines 1 thru 95 back. Although I have used info on lines 96 and on. Any help would be appreciated.

A:Microsoft Office 2010 - Excel problem

Do you mean you hide them? Use the Unhide function:

Read other 3 answers
RELEVANCY SCORE 59.6

When I open excel, and go to the file tab, it hangs, and says it is trying to contact server1......which likely is my head office server, and I can't access that server...It also tries to access the server when I want to insert a picture...how do I stop these programs from trying to access the server. I am in another country and will be for quite a while this is a large Pain....
I have changed the library folders to be resident on my computer and I have also changed the default save location to be resident...
Can anyone help?

I am on Windows 7, on a Dell laptop....

A:Microsoft office 2010 excel and outlook

  
Quote: Originally Posted by moshezhang


When I open excel, and go to the file tab, it hangs, and says it is trying to contact server1......which likely is my head office server, and I can't access that server...It also tries to access the server when I want to insert a picture...how do I stop these programs from trying to access the server. I am in another country and will be for quite a while this is a large Pain....
I have changed the library folders to be resident on my computer and I have also changed the default save location to be resident...
Can anyone help?

I am on Windows 7, on a Dell laptop....


Are these files you are working on local to your machine or are they over some sort of network? If they are network files, it may be timing out trying to create temp/caches of the file you are working on as undo procedures. If it's a network file save a copy of it to somewhere local on your computer and try editing it.

Read other 3 answers
RELEVANCY SCORE 59.6

Hi, I installed Microsoft Office 2003 on Vista running laptop and got error each time I want to open word or Excel document The command cannot be performed because a dialog box is open. Click Ok and then close dialog box to continue. Then installer running and document opens. I tried to follow the Microsoft advice to delete the template in the startup folder, but the folder is empty.
http://hidev.com/technical/office031.asp
Please help.

Thanks
Leon

Read other answers
RELEVANCY SCORE 59.6

In both Microsoft Word and Microsoft Excel, when I do a "File, Open" command, a box comes up showing the contents of the last directory I used. If I then attempt to use the drop down from this box to navigate to a new directory, it takes 65 seconds before the drop down list appears, and then another 30-40 seconds before the drop-down menu responds to my request for a new directory.

I have uninstalled and re-installed Microsoft office, and I have run the "detect and repair" option in the help menu. Nothing seems to fix the problem. I have no idea why this is happening or what Microsoft Office is doing during those 65 seconds to produce the drop down list and during the following 30-40 seconds to navigate to a requested directory in the drop down list.

I do not have this problem with other applications such as Lotus 123.

Any ideas?
 

A:problem with microsoft office xp word and excel

Read other 8 answers
RELEVANCY SCORE 59.6

Good afternoon,

I use a spread sheet which contains Check Boxes, that I manually tick to show a task has been fully completed. I have a basic formula that calculates returned items, and once it reaches 0 (all returned) I tick the box. I wish to have the Check Box auto-tick itself once the returned items count reaches 0. I'm damned certain this is possible, but beyond my abilities. I know you can have formulas to display text once a Check Box is ticked, I am kinda trying to do it the other way around.

Thanks for any help

Darren
 

A:Microsoft Office Excel 2010 Check Box

Darrenbilly said:





I'm damned certain this is possible, but beyond my abilities.Click to expand...

You are correct, it is possible.

What you need to do is learn the Visual Basic for Applications coding in Excel. Then you can add code that runs every time the sheet calculates (basically when something changes on the page). The code can check the status of a cell and change the status of another cell (or object in your case) based on criteria you have coded.

I'm not a programmer but playing with Excel Macros (VBA coding) and manipulating excel cells is a long time hobby of mine.

The easiest way to learn is to record Macro's and then study the code. It is easier learning the code if know first hand what it does. After you are familiar with how the code works, you will be surprised at how easy it is to code your own macros. Once you have the macro working for you, it is easy to move the code and have it run every time the sheet loads, calculates, closes, or several other possibilities.
 

Read other 10 answers
RELEVANCY SCORE 59.6

Hello everyone,

I have two questions regarding Microsoft Office Excel 2007, that are no doubt simple ones to answer.

Firstly, is it possible to have a column where every entry added would appear automatically with quotation marks? For example, if I entered Movie #1 in to a cell in Column A, when I click out of that cell, can it automatically change it to "Movie #1"?

Secondly, on a seperate work-sheet (but within the same work-book), how can I have a display telling me how many cells appear in a particular column on another work-sheet? For example, if I have Column A in Work-Sheet #2 filled with entries, can I have a cell in Work-Sheet #1 tell me how many entries there are there in total?

I hope that all makes sense.

Any help would be appreciated!
 

A:Solved: How Do I Get Microsoft Office Excel 2007 To Do This...?

Read other 7 answers
RELEVANCY SCORE 59.6

I downloaded a registry checker program to fix my computer(win98SE). Now I can't open
none of the microsoft office programs, its saying no application found,need to install program again. Also some other programs on my computer I can't open.
 

A:microsoft office : word,excel,powerpoint,etc

looks like you registry program may have deleted the links to some of your programs
did you make a backup of your registry at all -

try not to reboot - as I think win98 should back up the registry on each boot - but it only keeps a few copies - 5 I think

i know other members here are far more expert at this then I - so hopefully they will answer

but an answer to
did you make a backup of your registry at allClick to expand...

would be useful

also what was the registry checker program called - may help
 

Read other 2 answers
RELEVANCY SCORE 58.8

I am creating a worksheet about financial repayments, where the repayments are irregular.

Say for example the total repayment is £1000 and I put this in cell D1 ( alongside other headers). I am putting the repayments in column C, so the first entry would be in cell C2.

What I want to know is whether or not there is a very (I mean VERY) simple way to format column D so that any entry in cloumn C will be automatically subtracted from the first figure of £1000 and subsequent running totals and if so will I also be able to format column D as a £ figure (I know how to do that but not with any other formatting)

Yes, I know I sound very lazy (I am), but my maths are poor and it will be a long list, so if I make just one error it will be a load of hassle.

I would be obliged for any assistance.

Thank you
 

Read other answers
RELEVANCY SCORE 58.8

Hiya

The Spreadsheet Web Part Add-In for Microsoft® Office Excel 2003 makes it easy to design your own Spreadsheet Web Parts and save them to a site based on Microsoft Windows® SharePoint™ Services.

System Requirements
Supported Operating Systems: Windows Server 2003

Microsoft® Windows® SharePoint™ Services
Microsoft Office Excel 2003
http://www.microsoft.com/downloads/...74-d960-4d14-a9df-9024e39f5463&DisplayLang=en

Regards

eddie
 

Read other answers
RELEVANCY SCORE 58.8

I have a document in word that I merge with data in an Excel sheet. This worked fine for years. One day it gives me the can't establish connection message to the DDE. No big deal, I unistalled and re-installed...fixed.
2 weeks pass and it starts again, so I uninstall but when I re-installed I got the following error during setup:

Error 1919. Error configuring ODBC data source: MS Access Database, ODBC error 6: Component not found in the registry. Verify that the file MC Access Daatbase exists and that you can access it.

I don't even use Access. Regardless I hit Ignore, (only thing that will make it go away), and it will merge for 2 weeks or so and then quit again and I have to do the same thing over and over. I even tried upgrading to Office XP but had the same problem about 2 weeks after installing.

Also when this happens you can't use the find feature in other Excel documents.

I have tried all of the "suggestions" Microsoft has offered. NONE WORKED

Help?
 

Read other answers
RELEVANCY SCORE 58.8

Product
Microsoft Office Excel
Problem
Stopped working
Date
4/4/2010 2:22 PM
Status
Solution Available
Problem signature
Problem Event Name: APPCRASH
Application Name: EXCEL.EXE
Application Version: 12.0.4518.1014
Application Timestamp: 45428263
Fault Module Name: OLEAUT32.dll
Fault Module Version: 6.0.6001.18000
Fault Module Timestamp: 4791a74f
Exception Code: c0000005
Exception Offset: 00004580
OS Version: 6.0.6001.2.1.0.768.2
Locale ID: 17417
Extra information about the problem
LCID: 1033
Brand: Office12Crash
skulcid: 1033
Bucket ID: 645573241
I really appreciate all the good people out there could offer me a solution to solve my MS Excel crashing each time-by teaching me the 'step by step' to put the above solution generated after each crashed to good effect. Thanks. - Marc.
 

A:Solved: Microsoft office Excel-Pls help to decipher solution

Read other 6 answers
RELEVANCY SCORE 58.8

Hi everyone. I am having a problem opening a file that I was previously able to open and edit with no problem. I am getting two errors. One basically says that the file cannot be accessed and the other basically says that it cannot access the file and that the file may be encrypted. Well, the file is encrypted. I tried to unencrypt the file but I was unsuccessful. I originally encrypted the file using Windows XP which is the operating system that I use on my computer. I fear that the file has become corrupted and cannot be recovered. I can only hope that you all can help me to recover my file. I do not have a backup of the file but I do have a printout of it so I can make it up again if I have to. Unfortunately, I'll have to readd some stuff on it that I have added to the file since the file was printed. Luckily, it is a recent printout. So, can I recover my file? If so, how? I have included screen shots of the two errors but I blacked out the file name for privacy reasons. Thanks in advance!
 

A:Microsoft Office 2002: Excel cannot open a file

Well everyone, the problem is solved. Turns out that my entire Microsoft Office 2002 suite had become corrupted somehow. I haven't scanned for viruses yet but I plan to soon so as to avoid this problem in the future. I am also making sure to do a weekly backup of all my documents from now on. Later!
 

Read other 1 answers
RELEVANCY SCORE 58.8

I need to know if I either need to buy a new computer or is this computer going to be good after I update it?????

A:need help with Microsoft Office Excel & errors on page onlin...

@AmieeM Hello;Allow me to welcome you to the HP forums! Sorry, I do not understand your question about the computer still "being good"? Your thread title mentions Office Excel error -- and we do not have the resources to debug MS Office application problems.  So, if that is the issue, you would need to contact Microsoft for assistance. IF that is not the issue, then please provide more details.

Read other 1 answers
RELEVANCY SCORE 58.8

I noticed that on my Dell Latitude pc that is Windows 7, that Excel 2016 works fine when i paste from a certain site and then insert rows and delete rows. No issues on the Dell. On the Lenovo, there are strange things ..  delays.So i insert a row and then nothing happens. So i scroll the info off the screen and then back and boom, the row is inserted or deleted depending on what i did.  Also sometimes i have to click a few times to get the cursor into the cell.  When i adjust column sizes it is the same thing. I have to scroll up and down to make sure everything takes.  What is the problem with this on this machine. It doesnt happen on my old Dell. Any ideas? Excel works fine on the Lenovo when i am not pasting in information from that website.

Read other answers
RELEVANCY SCORE 58.8

1. For a while the computer has become very slow, to open a file takes two minutes and to print a page takes five minutes.

2. Unable to open excel file directly, a blank page comes up, have to go to FILE and then select particular file to open.

I have been told to reload M/S programme to resolve this problem. Is it correct?
 

A:Microsoft office excel files - cannot open directly

XP ???
This is what I do ...
http://my.opera.com/Jarrah/blog/how-to-make-excel-open-each-file-in-a-separate-window
 

Read other 2 answers
RELEVANCY SCORE 58.4

I am creating a worksheet about financial repayments, where the repayments are irregular.

Say for example the total repayment is £1000 and I put this in cell D1 ( alongside other headers). I am putting the repayments in column C, so the first entry would be in cell C2.

What I want to know is whether or not there is a very (I mean VERY) simple way* to format column D so that any entry in cloumn C will be automatically subtracted from the first figure of £1000 and subsequent running totals and if so will I also be able to format column D as a £ figure (I know how to do that but not with any other formatting)

Yes, I know I sound very lazy (I am), but my maths are poor and it will be a long list, so if I make just one error it will be a load of hassle.

I would be obliged for any assistance.

Thank you

* Particularly, I dont anything about macros or visual basic (but basic is what my knowledge is)
 

A:Solved: Microsoft Office Excel 2007- Automatic Subtraction

Read other 8 answers
RELEVANCY SCORE 58.4

I know I can do this as I have done it in the past a long time ago. Using the Find and Replace option add and extension to my sku numbers, such as:

SKU #

8686708052

I have a column of these sku's and want to add the extension .jpg to all of them at one time!

8686708052.jpg

I have done this in the past and can't remember what I did and it worked great instead of having to manually add the .jpg extension to every sku #!

Thanks!

A:Microsoft Office 2007 Excel Find and Replace Command

Might this be what you are looking for ...

[SOLVED] adding text to end of all cells in column

Read other 2 answers
RELEVANCY SCORE 57.6

I've got two different spreadsheets in Microsoft Office Excel 2007 that rely quite heavily on graphs. Now, the issue I'm having isn't stopping the practical functions of the spreadsheet, but it is aesthetically frustrating.

Each time I access either spreadsheet, some of my graphs data labels reset their formatting and styles. Approximately 75% of the data labels remain as they were originally formatted, but approximately 25% of them reformat themselves each time. I correct it by formatting them the way I'd prefer, and I re-save, but the next time I open the spreadsheet they've gone back to their default state.

Now, this is only the formatting, not the content of the data label, but it is still frustrating.

Can anyone please give some advise as to how I can fix this?
 

A:Graph Data Labels Resetting In Microsoft Office Excel 2007

Is anyone able to help me with this, please? It's such a frustrating issue.
 

Read other 1 answers
RELEVANCY SCORE 57.6

Quote:
Microsoft has officially confirmed attacks targeting a Critical 0-day vulnerability affecting various releases of Office Excel. According to the Redmond company the vulnerability is actively being exploited in the wild, and a patch is in the works, although no security update is available as of yet to resolve the flaw. The Microsoft Excel Invalid Object vulnerability is rated as Critical because it can allow an attacker to perform Remote Code Execution on an affected system in the eventuality of a successful attack. Attacks against the security flaw generated by a Boundary Condition Error have initially been reported by security company Symantec.


more: Softpedia

A:Microsoft Confirms Attacks Targeting Critical 0-Day Office Excel Vulnerability

so...... uninstall excel

0-day??


thanks for the heads up Airbot

Read other 1 answers
RELEVANCY SCORE 57.6

Microsoft has officially confirmed attacks targeting a Critical 0-day vulnerability affecting various releases of Office Excel. According to the Redmond company the vulnerability is actively being exploited in the wild, and a patch is in the works, although no security update is available as of yet to resolve the flaw. The Microsoft Excel Invalid Object vulnerability is rated as Critical because it can allow an attacker to perform Remote Code Execution on an affected system in the eventuality of a successful attack. Attacks against the security flaw generated by a Boundary Condition Error have initially been reported by security company Symantec.



more: Softpedia

Read other answers
RELEVANCY SCORE 57.6

I get the following message when I open Excel, Word and Powerpoint (Publisher works, but dare I try any others?)



Excel Failed to start correctly last time. Starting Excel in safe mode will help you correct or isolate a startup problem in order to successfully start the program. Some functionality may be disabled in this mode.

Do you want to start Excel in safe mode?




If I click yes or no it doesn't do anything, (on occasion Ill get a message prompting to diagnose and repair, a couple of minutes later it says i's successful but back to square one)

I have just installed SP1 in hopes there's some sort of fix, to no avail
I have tried a repair via the installation disc
I am hoping I don't have to uninstall / reinstall because I don't know if the licenses are limited

If anyone could shed some light on how to fix it, I would greatly appreciate it!


OS: Windows XP with SP3
Model: Compaq Presario V5000
Office: Microsoft Office Home And Student 2007
Specs: Pentium M 1.46Ghz CPU, 512MB RAM
 

A:Issues opening Excel, Word and Powerpoint - Microsoft Office 2007

A reinstall of Office 2007 will be the quickest fix.
 

Read other 19 answers
RELEVANCY SCORE 57.2

I am currently working on a spreadsheet for a complex budget, and the spreadsheet is constantly expanding by way of additional columns (a new column for each day).

At the end of the columns that represent each day, there are five columns that show calculations based on the entries in the columns that are before them. One of those columns calculates the average of every entry in that row. In the sixth column, we want to be able to calculate the average of the last four day entries without having to manually adjust the range each time we expand the spreadsheet.

That's probably not particularly clear, so in summary, we have a column for every day of the last twelve months. Each cell shows a dollar amount. At the end of each row, we have five columns that display various calculations for each row. At the end of those calculations, we want a further calculation that will show us only the previous four days.

Needless to say, every time we add a column for a new day, the range (showing the average of the previous four days) expands to show the average for the last five days. Rather than this happening, we need the range to move forward, rather than expanding, essentially following the cell at the end of the row that shows the average of those four days.

In essence, we need a cell to calculate the average of four cells that are five cells behind it, without ever expanding its field of reference.

Apologies if this description isn't particularly helpful...it's a dif... Read more

A:Solved: Relative Cell Ranges In An Expanding Spreadsheet (Microsoft Office Excel)

Read other 8 answers
RELEVANCY SCORE 56.4

I have a spreadsheet that shows all of the upcoming events at my work (I've attached a very basic example of the way the spreadsheet is set out).

When an event passes, I'd like the spreadsheet to automatically change the formatting of the rows that contain events that have already passed.

For example, today being 14.12.09, an event for yesterday (13.12.09) would be highlighted in red to show that the day has passed.

If anyone can provide any detail on how to achieve this, I would greatly appreciate it.
 

A:Solved: Conditional Formatting Based On Date Range In Microsoft Office Excel 2007

Select your data, then Format > Conditional Formatting.

Condition 1; Formula is:

=$A5<$D$2

Click Format > Patterns > red colour > OK.

Click OK.
 

Read other 2 answers
RELEVANCY SCORE 56.4

Recently, I noticed that my Yoga2 Pro's display keeps blinking and flashing whenever I interchange from Adobe Reader to Google Chrome. The display will just turn black for 1 sec and turn back ON again. Same issue with Office software such as Powerpoint or Excel. If I just work on 1 program and don't interchange programs, the display will be fine. I am very sure it is a display driver issue and it occurs after Win 10 updates. Booting in Safemode also will prevent that problem from happening. The Display driver listed on this website is not working http://pcsupport.lenovo.com/us/en/products/LAPTOPS-AND-NETBOOKS/YOGA-SERIES/YOGA-2-PRO-LENOVO/downlo... and will have the same issue with Intel 4400... I know that this model is obsolete and the warranty is expired. But this is obviously SW update/Driver issue with Win 10. Could someone from Lenvo help to fix this? Thanks a lot!

Read other answers
RELEVANCY SCORE 56.4

I have two problems with my pen in Microsoft office 2016 that I was hoping to get help with.

1. When you open up Microsoft PowerPoint 2016, initially your pen works as a mouse, and then when your pen gets close to the screen, the pen icon appears as a tab. The problem that I am experiencing is that my pen is stuck in pen mode instead of mouse mode.
Now that isn't really a problem because I use that is mostly why I use it, but when I am writing on my PowerPoint, it spontaneous changes to a mouse without me wanting it to be. This is very frustrating because it sometimes moves around what I write and misses
some letters I try to write. I have had this problem for over 6 months and I go to the Microsoft store and they never have an answer for me because of how rarely it occurs. I was hoping if anyone has idea how to fix this problem.
2. This problem has begun a couple weeks ago. When I am in PowerPoint 2016, my pen is not getting picked up on the PowerPoint slide. It can click on the tab buttons, but not on the actual slide.
Thank you in advance for the help!

Read other answers
RELEVANCY SCORE 56.4

My microsoft office is not working properly as the document or text file is not been saved by it. All my important text and document are being lost as it not been saved. Every time while saving it create temporary file and an error occur. Plz help what to do.
 

Read other answers