0
votes
0answers
9 views

Editing registry for the error - One of your object libraries (I) is missing or damaged. Please run setup to install it

When I opened an excel (.XLS) file today, I got an error - One of your object libraries (I) is missing or damaged. Please run setup to install it. I don't know why that happened, but it could be ...
0
votes
0answers
22 views

Powerpoint 2013 - CPU spike

for some reason when i run PPT and/or Excel 2013, and even despite pretty robust and new system (see below, please correct me if i am wrong), my computer commands of large amounts of memory and CPU, ...
0
votes
2answers
42 views

Where does Internet Explorer save the files which I have opened? [duplicate]

I opened an Excel file from Internet Explorer, worked on it for 2 hours and saved it. But now I can't find the file. The file was really important. Is there any way I can retrieve it? I'm using ...
2
votes
2answers
20 views

Same time value in two different cells, different decimal value, no match possible

I'm trying a index match function on two different cells in which is the time value 08:30:00. I never got a match and after long searching I found that there's a minuscule difference in value between ...
0
votes
0answers
32 views

Conditioning Format

I have two worksheets in one workbook. I have two columns of numbers and texts in the first worksheet that I want to duplicate to the second worksheet if there is a dollar value in a cell on the ...
0
votes
3answers
54 views

Excel documents will open excel with blank window

When opening any excel document it will only bring up the excel window. To open the document I will have to goto file -> open. I am using Office 2013 on windows 7 64bit Only started happening the ...
0
votes
0answers
34 views

Writing formula in excel 2010

I'm trying to make a sheet read all past bill data from a main rundown in order to do this i need to have one cell copy the date and keep it even after i change the original date then have the next ...
1
vote
3answers
49 views

How to check what files a process has written into

I have an Excel application that stores some information somewhere in my computer, and I need to know where that file is located. This Excel file is some kind of Visual-Studio-created Excel ...
3
votes
2answers
904 views

Why is Excel 2010/2013 taking 10 seconds open any file?

I have a fast Windows 7 PC with two SSDs and 16GB of RAM, so I'm used to programs loading very fast. But recently, for no reason I can figure out, Excel has started taking way too long to open Excel ...
0
votes
0answers
14 views

Adding e-speaking command

I need quite some help witht the speech recognition program "e-speaking" in a Windows 7 system. The situation is as follows: I need to add a new command. I want, when a specific phrase is spoken ...
0
votes
1answer
40 views

IF (AND () function does not work as it should be

When I write the following simplified command in a cell, =IF(AND(C6="A";D6="30");D2;0) it does not appear the value of the cell D2 but zero, depsite the fact that the 2 assuptions of IF(AND) are ...
1
vote
1answer
41 views

Conversion of delimited .Txt file into Excel file [duplicate]

I have a delimited .Txt file containing several fields (separated by spaces) and I want to know how can I copy the entire thing into the MS Excel using any script (JS/VB/DOS Command) which can be ...
1
vote
1answer
28 views

Tool for converting tables into 2nd, 3rd and 4th normal forms? [closed]

I'm looking for a tool that will convert a table, in CSV format, into 2nd and 3rd normal forms. I've found many tutorials and examples on the process, but no tools. I'm running Windows 7 on PC.
4
votes
1answer
353 views

Excel 2013: “We couldn't free up space on the clipboard. Another program might be using it right now”

Excel 2013 often complains that "We couldn't free up space on the clipboard. Another program might be using it right now" when I'm trying to copy cells. Some say it might be caused by Zone Alarm or ...
0
votes
1answer
28 views

Copying formulas, macros, headings.. but not data

I created bookkeeping spreadsheets for 2013. I want everything copied for working in 2014, but I don't want the data. I suppose I could go through everything and make sure that it's Protected, then ...
0
votes
2answers
33 views

“#REF!” appears in cell after referred-to cells are pasted in

On Office 2007's Excel on Win7, I have a file with a formula like AVERAGE(A29:A33) in cell A34. I then copy four vertically-adjacent number-containing cells and paste them into cells A29:A33. At ...
5
votes
1answer
152 views

Excel comments and elements appear all black except on primary monitor

I've had this problem with Excel 2007 and 2010 on two different PCs, both running Windows 7. My computer has 3 displays, with the center monitor primary. When Excel is open in one of the non-primary ...
0
votes
1answer
83 views

Access Database engine Issue

I have recently moved from 32 bit to 64 bit version PC which runs 32 bit version of Office package. I have an application (.net 4.0) which handle excel files and which uses the ...
-2
votes
1answer
51 views

Excel formula to calculate taxes

I have the cost of a ticket without taxes on N45. I want to calculate 7% of that (take out comm. %), then add taxes from P45, but what formula do I use for that? Say I have a ticket price for $100.00 ...
1
vote
2answers
73 views

Tab key moves down instead of right in Excel

When I use the Tab key while in Excel, the cell moves down instead of to the right. How can I get the active cell to move to the right when the tab key is pressed?
2
votes
1answer
181 views

Use Excel Color Scale Formatting with Text

I use Excel sheets to track the status of tasks through a set of discrete statuses. I'd like to be able to format these automatically, with the start being red, the end being green and progressing ...
1
vote
0answers
115 views

How to avoid security certificate errors/warnings raised by excel when retrieving data using querytables

How can I avoid security certificate errors/warnings raised by excel when retrieving data using querytables from a server that has multiple certificates (we do not wish to revert to the use of ActiveX ...
1
vote
2answers
267 views

Excel File Names not Displayed

Problem: When excel windows are minimised, I can't see the file name, all I get is a rather unhelpful 'Microsoft Excel' proceeded by the file name. I have the taskbar docked on the left, and have ...
4
votes
2answers
74 views

Select only visible cells

I'm looking for a way to take a column of data (70 some rows) with some visible entries, some empty cells, and some formula results. I'm looking for a way to copy out only the entered data and formula ...
1
vote
1answer
306 views

excel macro with column criteria to copy two rows in one sheet to another

I need a macro that searches for a string in a column; on finding that string it copies the row in which that string is found as well as the row above that. For example: Search for "boy" in column ...
1
vote
0answers
87 views

Excel97 crash, Windows 7, VBA, DEP

I've not be able to get Excel 97 VBA to run correctly on Win 7 without turning DEP entirely off. Access97 runs ok with just an Access DEP exception, But making Excel a DEP exception has not helped. ...
0
votes
2answers
247 views

Excel taking too long to open network files that already open by another user

Opening Excel (MS Excel 2010) files over the shared network drive (linux samba share) opens up instantly (1 second). That is, unless its not already opened by another user. If the file is already ...
1
vote
0answers
152 views

How can I copy spreadsheet cells into word document?

I'm trying to copy a selection of cells within a spreadsheet across the word and have changes appear in both sp doc and Wd doc. I have read this answer you gave from another with the same quest: ...
0
votes
0answers
71 views

Excel 2010 error message when file is an attachment

"There was a problem sending the command to the program" is error I get...Running 2010 and Windows 7. I've tried the DDE fix, tried the explorer pane suggestion as well. If the file is on the desktop ...
2
votes
0answers
1k views

64-bit Excel 2010 Solver - Solver32.dll not found

I am trying to use Solver in 64-bit Excel 2010. When I run Solver, it opens the solver window, states that it has results and then popups the following error message: Run-time error '53' ...
8
votes
2answers
839 views

Prevent Excel from clearing copied data for pasting, after certain operations, without Office clipboard

Whenever you copy a cell or a range of cells in Excel (my version is 2010 on Windows 7), and then do something else like insert new sheet row or simply edit another cell, Excel removes the clipboard ...
0
votes
0answers
113 views

“Error applying transforms” when opening XLS files

I think I have an association issue with Excel 2010. Whenever I click on a XLS file I get a Windows Installer window saying "Preparing to install" and then this window: It says, Error ...
-4
votes
1answer
78 views

How to open files when the sources are in a column of another file

I have a large three-column Excel file: first column is "data (Excel file) name" second column is the "data source(of that Excel file's data)" and third column is "remarks" visit link for see ...
1
vote
1answer
4k views

VBScript in Windows 7 64bit Scheduled Task - Works with only run when logged in

So basically I have this VBScript that opens up an Excel 2010 instance, run a macro in it and close the spreadsheet. I am calling it using Scheduled Task to automate it. It ran beautifully when I was ...
4
votes
2answers
4k views

How can I change a hyperlink's default open-with behaviour in Excel?

Using Office 2010 running on Windows 7, I have a hyperlink in Excel to a JPG on a drive: =HYPERLINK("\\myserver\dir1\file.jpg", "Link") The problem: when clicked in Excel, this link ONLY opens in ...
0
votes
0answers
98 views

Suppress now printing dialog - Microsoft VBS

Context: I'm trying to create a task in Windows to automatically print a file at certain hour of the day whether the user is logged on or not. I've read on the web that in order to execute a task ...
1
vote
1answer
962 views

Excel 2007: Intermittent 0xc0000005 crashes

Hello there SuperUser Hive Mind. We are having an issue at the office I work. One of our users who has a workflow which consists mostly of Excel documents with dynamic formatting and macros which she ...
0
votes
4answers
323 views

Can Excel automatically adjust cell contents to retain a consecutive pattern?

I'm typing a string of consecutive numbers in individual cells. After completing the string, I go back and delete the contents of one of the cells in the column. Is there a way that Excel can then ...
0
votes
1answer
149 views

Open .tdt files in Excel by default

I routinely use Excel for TDT and other formats. I've never had a problem getting Windows to open .tdt files in Excel by default; in Windows 7, it's right-click | Open with | Choose default ...
2
votes
1answer
770 views

Excel 2010 shows different cell fill colors depending on Windows Appearance Settings

I just noticed something very strange. I created an Excel workbook in Excel 2010 (Windows 7) and manually formatted alternate rows with slightly different colors. When my colleague opened the ...
2
votes
1answer
148 views

Formulas are not calculating after password protecting a sheet

Does anyone know why after password protecting an excel document, and by only ticking the 'select unlocked cells' option, the saved document will not automatically calculate the formulas once is ...
0
votes
1answer
362 views

When launching Excel 2010, multiple unwanted macro windows open

When the user launches Excel 2010, it will open five or six windows of excel macros. I know that this is typically removed by accessing View > Macros > Remove the macro but due to the fact that ...
0
votes
1answer
69 views

Hyperlink to other worksheet using hyperlink function in excel 2003

I want to hyperlink a worksheet from a worksheet containing a cell A1 having name of the sheet to be hyperlinked & friendly name. For example I have a worksheet summary with Cell A1 having its ...
3
votes
1answer
291 views

Is there any tool that let you batch export excel tabs to csv

I have Excel 2010. Found this: Batch XLS to CSV Converter But I actually need to export all excel worksheets as individual CSV files. Not sure if it works that way. Also if I were to use the above ...
0
votes
1answer
167 views

excel last auto save is a month old

I was working on an Microsoft Excel 2010 document when all of a sudden my computer either crashed or rebooted I'm not sure exactly all I know is when it finally turned back on my document last auto ...
1
vote
0answers
209 views

VBA code not refreshing external query

I have a small Excel file with VBA. We use the task scheduler in Windows to open this small file which then runs a macro to open, refresh, and save various reports that we have automated. The file ...
4
votes
1answer
455 views

Excel open option missing from Context Menu

Whenever I select multiple Excel (2010) files the right mouseclick option 'open' disappears. When I select just one or a few files there is no problem, but from 15 or more files I can't open them at ...
0
votes
0answers
67 views

Copy-pasting data between worksheets causes all previous data to be lost

I copied content from one worksheet and pasted it into another worksheet (in same file). The problem is that all worksheets lost previous data and shows me data which I pasted from last time. How do ...
1
vote
0answers
428 views

Excel shuts down in Windows 7

I have written an employee payroll program using Excel 2000. It runs fine on my computer running Vista. When I port it via a flash drive to a Windows 7 computer and run it from the flash drive, it ...
3
votes
2answers
431 views

Languages of Microsoft Office

I am in France, and I just bought the CD Microsoft Excel 2010. While installing it, there was no option to choose the language. After the installation, the language is in French which matches the ...