-2
votes
1answer
40 views

Randomize Huge List - Windows 7

i've been searching for a solution for this but i couldn't find it anywhere. I have a large list, more than 2 million entries. I need to randomize it. I can randomize lists in excel but excel ...
1
vote
0answers
28 views

Is that possible to have a Shamsi (persian) Calendar in Windows? What about Microsoft Office

Is there any solution for replacing the current Georgian Calendar of Microsoft Windows with Shamsi (Persian) Calendar? Although, Microsoft Excel and other packages of Microsoft Office must recognize ...
0
votes
1answer
30 views

How to display the Last value in another Cell

I use this formula in E5 to E25 =IF((C9=""),(""),IF((D9=""),(""),E8-C9+D9)) Now I want to display last value of E in G3
0
votes
1answer
30 views

Excel 2013 wont let me save XLSX files

So, just recently when I tried to save an excel (.xlsx) file in Excel 2013, I got the following error message: I have not changed my file block settings in the trust center however. Here is a ...
-2
votes
1answer
24 views

Excel Vlookup across 2 workbooks

I have two columns of data in different excel workbooks: I want to compare all the data in column C of Workbook 2 against the data in Column D of Workbook 1. If the data in column C matches the data ...
0
votes
1answer
27 views

Automatically Copy the only Credit rows into a Sheet

I am trying to use a formula by the below, With out use Developer Options. I have a excel workbook and there is a two sheets One is - One sheet is (sheet1)- TXN. ID Transection Type After ...
0
votes
0answers
22 views

Excel value of the digit or alphanumeric formula

How to convert a price or value of the digit which is taken as a formula to an alphanumeric? Example :p o l i c e m a n w x y 1 2 3 4 5 6 7 8 9 10 ...
0
votes
1answer
25 views

IN EXCEL, how do you add 2 columns then blank one of the columns without effecting the balance?

inventory # EX col A -10 B 25 currently Question: If col A changes next month to -5, how can you blank out A-10, replace it with A-5, without effecting B. A - ...
2
votes
0answers
93 views

Different icons for different excel files

In my work, all coding can be done in VBA only - hence, all of our tools (dbase queries, data processing, cash overviews, etc) are written as xlsm files. At the moment, the number of different tools ...
1
vote
2answers
150 views

Excel tries “Accessing Printer” while opening specific workbook

Excel 2010 (Windows 7 Professional 64-bit) is loading a specific Excel file to 100%, then the status message on the splash screen rotates between "Opening (100%)" and "Accessing Printer". It sits and ...
2
votes
1answer
229 views

Copying a multiline text into a single cell in Excel

I want to copy the following: line1 line 2 line 3 into a single cell in Excel. I know that I can use the combination Alt+Enter on Windows and Ctrl+Alt+Enter on Mac to create a line break in ...
0
votes
1answer
35 views

Using Parallels, Win 7 and Excel 2010— Excel restores itself immediately after being minimized

I'm using Excel 2010 in Windows 7, through Parallels on Mac OS X. Some times, when I go to minimize Excel, after the minimization animation, Excel immediately restores itself. How can I fix this ...
1
vote
2answers
51 views

Copy selected items in Excel filter

I have been strugling for past several day trying to resolve this issue. Here is what I have and what's needed: I've got about 20 Excel sheets that contain massive data (around 50K rows/sheet) that ...
0
votes
0answers
27 views

Microsoft Excel and Omnis hang sometimes when connected to domain

This is a very bizarre problem a customer is having. When his laptop (Windows 7 Pro) is connected to the domain, the chance exists that Microsoft Excel, Omnis, and maybe some other applications will ...
0
votes
0answers
209 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
61 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
84 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
37 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
34 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 ...
1
vote
3answers
4k 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
42 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, and then have the ...
1
vote
3answers
133 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
6answers
4k 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
20 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
50 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
84 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
32 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
784 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
43 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
381 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
156 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
82 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
133 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
375 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
161 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
3answers
701 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
76 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
330 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
109 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
310 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
199 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: ...
2
votes
0answers
2k 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
2k 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 ...
-4
votes
1answer
79 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
5k 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
7k 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
121 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
1k 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
454 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 ...