0
votes
1answer
27 views

Excel shows different files in same window

In Firefox, I downloaded an Excel spreadsheet and it displayed a dialog box asking what to do with it, so I selected "Open in Excel". Then I downloaded another Excel spreadsheet and opened that one ...
-2
votes
1answer
32 views

sum the values in a column and add the sum to the filename of a workbook

Hello I have been able to create new worksheets based on unique values in a column. In addition to this, i want to sum up the values in a column and include this sum in the filename of each ...
0
votes
0answers
15 views

Excel workbook contains a userform which opens up black on 8.1 office 2010

The userform within the worksheet opens black on windows 8.1 office 2010, yet it opens fine on XP with office 2010. It's a excel 79 to 2003 xls file. We checked trust centre on 8.1 but no joy, ...
0
votes
2answers
43 views

Excel - take two csv files and map them

I have two csv files. 1 has a list of emails, another has a longer list of emails with first names, last names, address, etc. What I am looking to do is take both of these files and map the emails ...
0
votes
1answer
36 views

Trying to get an alert if three seperate cells do not match

Hi I am trying to put 2 formulas together in one cell The first is to give a sum, i.e. : =(D3+F3+H3+J3)-(C3+E3+G3+I3) The second is to check the resulting number above against a number total in 2 ...
0
votes
1answer
82 views

VBA Lookup by Multiple Criteria - Then Copy & Paste

Currently I have a 2 way database with 10+ fields and 1,000+ rows. Some fields are customer name, car model, year of model, price, date of purchase. I would like to lookup rows of data by multiple ...
-1
votes
1answer
42 views

How to count two different column?

I really need your help regarding the below table, I need a formula to show me how many pending/closed for each project. Project Status Project Pending Closed VIVA closed ...
0
votes
2answers
47 views

From column to matrix

I have few addresses in a single column. Need to move it to rows as below: name1 street1 city1 state1 phone1 email1 name2 street2 city2 state2 phone2 email2 NAME ADDRESS PHONE EMAIL name1 ...
0
votes
1answer
194 views

Run Command to open csv file in excel

My first question on the site, so hopefully I'm doing this right. I use file juggler on my windows machine. The program can watch for new files and trigger run commands. When a new csv file arrives ...
0
votes
1answer
191 views

Disable custom view in Excel

I am using a shared excel workbook that everytime a user accesses it and saves it, it saves a Custom View for them. I want to disable this settings so that every one can see only same view of the ...
1
vote
2answers
131 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?
0
votes
0answers
92 views

What is the Windows equivalent of this Mac Excel shortcut?

I can't remember how I learned how to do this, but I'm 90% sure it's a built-in default shortcut for Mac Excel 2011. Make a selection in your spreadsheet. Hit option-tab to move that selection to the ...
0
votes
1answer
68 views

Recreate folders structure

I am using program called "Advanced File Organizer" to catalog my folders, It just create a structure copy of folders with names, sizes and types. That is great, But I want to recreate this structure ...
3
votes
1answer
3k views

How can I move linked Word/Excel files without breaking the links under Windows 7?

I currently operate under Windows XP and have multiple links between my Word and Excel files. I have to upgrade to Windows 7. When the .doc and .xls files are converted to .docm and .xlsm, ...
1
vote
3answers
694 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 ...
0
votes
0answers
61 views

Windows Excel 2010 Copying text to clipboard depending Upon values selected in Dropdown list in Excel

I want to select a value in drop down list and corresponding to that value some update should get copied on the clipboard .
2
votes
1answer
3k views

Bat file to open excel with parameters - spaces

I would like to run Excel, open a specific file in it and pass arguments to this file. My call is "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE" ...
0
votes
1answer
111 views

Associate a file type to a specific Excel workbook

I have a special extension (.dia) for storing electricity diagrams. Inside these files are binary, created by an Excel library (.xlam). For fast viewing of a diagram, I would like to bind the .dia ...
0
votes
1answer
75 views

how do i get a simple IF function to work in Excel only when another cell has a value in it?

How do I get a simple IF function to work in Excel only when another cell has a value in it? I've tried =IF(ISBLANK(G4)="Sold","Closed","Open") but that didn't work so I was wondering if anyone could ...
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 ...
2
votes
1answer
218 views

How to intercept registry or memory key?

How to intercept a registry or memory key while for example I am changing the Google Chrome window size? Is there a soft/freeware I can use that would list changes I am making in the computers memory ...
4
votes
1answer
89 views

Formatting legend position in Excel?

I have a bar chart with four different data sets in Excel 2010 and made a nice little figure from it. However, I now want to format my chart's legend. The legend has four entries in list format with ...
0
votes
2answers
59 views

Why am I getting a “name error” with this IF formula?

I'm trying to use this formula to output "Tie" when the result is a draw: =IF(B6>C6,B6-C6,IF(C6>B6,C6-B6,”Tie”)) Instead of giving me what I want, it gives me a "name" error. What am I ...
4
votes
5answers
18k views

How to open xlsx files with Excel 2013 by default on windows 8?

My xslx files open systematically with Excel 2010 when I'd like them to use Excel 2013. Everytime I right click select open with point to C:\Program Files\Microsoft Office ...
2
votes
2answers
95 views

Why is this simple Excel calculation not netting Zero?

It's supposed to be zero but for some reason the result produces a peculiar series of digits at the end. Also, here's the .xlsx of it: http://83.212.111.36/Book1.xlsx
0
votes
2answers
89 views

Excel IF Calculation

Please Help! I am a novice excel user and I am trying to get this formula to compute and not having any luck. Is there anything glaringly obvious to anyone? ...
1
vote
0answers
109 views

need excel files to be opened and maximize and always be opened

our computers in our company always turn on and we dont restart them... (if need hibernate them) some excel files in network drive shared and we want to open all over the time in some PCs which of ...
2
votes
2answers
181 views

Excel 2007 Images Embedded In Comments = File Too Large

I made a list of all the major electronics (pc towers, laptops, monitors, etc) at my workplace for inventory. To make it better I wanted to add pictures so I could see what each of the items looked ...
0
votes
2answers
57 views

Excel files are opening with PowerPoint instead

When I first used a flash drive containing Excel files, Microsoft Excel was not installed on my computer. So, Windows 7 opened it with PowerPoint and now all the Excel files on my flash drive open ...
0
votes
2answers
1k views

ODBC Data Source Administrator Window Crashes

I would really appreciate some help with this. Running Windows 2008 R2 EE x64 SP1 with latest updates Office 2010 X64 (verified) with latest updates When I create a System DSN with an Excel ...
6
votes
2answers
2k views

How to view large spreadsheet in Windows

What would you recommend to a non-technical Windows user for viewing (no need to edit) large spreadsheets (200MB - 5GB). Format is CSV and I am told Excel chokes.
1
vote
0answers
109 views

Encrypt Excel file on Windows for use on Mac

I have an Excel file open using Excel 2007 on a Vista PC. I wish to encrypt this file, and send it to someone to open on a Mac running Excel 11.6.6 (Office 2004). Is this easily achievable? I ...
0
votes
1answer
289 views

Change the temp directory for a user with Microsoft Word 2000

i have a project with a very strange architecture : several Microsoft Word are creating documents based on copy/paste of Excel graphs. Each Word is running with its specific account at the same time. ...
0
votes
0answers
94 views

work with huge 15000 lines excel files containing formulas

We work on a huge excel file. it contains a sheet setting 22000 lines We use Excel 2011 on Mac and Windows on Intel i7 with 8Gb Ram. We have disabled the automatic computation of the file the file ...
4
votes
1answer
458 views

Stop Excel from changing file contents upon open

I use synchronization a lot on my machines. Excel changes the modification date right at the very moment it opens the file. Then, it changes the contents of the file (I guess to update the statistics ...
0
votes
0answers
546 views

Full File Path in Reference to Another Workbook in Excel

I have two Excel files, one on D:\ and the other one on E:\. I reference one from the other, for example, using vlookup in the E: file to search from the D: file, like that: ...
1
vote
2answers
337 views

Excel formula - Absolute reference to cell

In my excel 2010 worksheet, I have entered a formula =+H8+N8*AA7 where AA7 is a permanent number where as H20 & N20 will change. But if I copy this formula to the below row, it pastes as ...
2
votes
1answer
104 views

Is it possible to export folders in the “All users” to excel?

I need to get a list of users that have logged onto a computer, i'm currently doing this at the moment by going into the Documents and Settings folder and copying and pasting the name of each ...
0
votes
1answer
3k views

Is there a way to get a shared spreadsheet to update without closing and reopening?

Using Excel 2010, I have a spreadsheet that is used by 3 different people at any one time. But if one person has the spreadsheet open on there PC the other people can only view it as read only. I ...
0
votes
3answers
109 views

Joining / nesting excel if statements in Excel

I have three statements: =IF(ISNUMBER(SEARCH($ET$2,B2)),B2,CONCATENATE("NA ",B2)) But I want to do =IF(ISNUMBER(SEARCH($ET$2 **OR** $ET$3 **OR** $ET$4, B2,CONCATENATE("NA ",B2)) how could this ...
0
votes
2answers
4k views

How to enable Record Macro function in Excel 2010?

After adding the Developers tab in Excel 2010, the Record Macro function became disabled. How can I enable it again?
0
votes
1answer
127 views

Sorting and giving unique values in excel

Can anybody help me for following problem: If we have 5 rows and 3 columns as 1 5 6 5 4 3 7 1 3 5 2 1 6 1 2 We sort this as follows: 1 1 1 5 1 2 5 2 3 6 5 3 7 4 6 Now I need ...
0
votes
1answer
204 views

How to get the difference between two dates based on an item (truck) number

I'm trying to set up a database for a co-worker to track information based on truck number, amount disposed, etc. Sometimes trucks are left with garbage at then end of the day. That truck may not be ...
1
vote
0answers
906 views

Open source, command-line tool to convert Excel .xls to .xlsx without Excel

I'm looking for an open source, command-line tool to convert files from the old, binary Excel ".xls" format to the new (Excel 2007) Open XML .xlsx, without Excel installed, on a Windows PC. Ideas? ...
1
vote
4answers
3k views

Excel cannot open an xlsx file

Excel cannot open a file called file.xlsx. The error states this is because the file format or file extension is not valid, and I should verify that the file has not been corrupted and that the file ...
1
vote
1answer
116 views

Flash drive file corruption [duplicate]

Possible Duplicate: How do I recover files from an USB flash drive? I think I may have pulled my jump drive out before it had time enough to save all the information. When I tried to open ...
2
votes
5answers
12k views

Excel freezes when copying / cutting to paste elsewhere

When cutting/copying some cells to paste them into another sheet/page, sometimes Excel freezes/locks up and fades out. At the top toolbar it says in brackets "not responding". Eventually, I must ...
1
vote
1answer
729 views

Filtering by currency in Excel

I have this situation in Microsoft Excel: Cells are formatted by using "Format Cells" and setting the Currency manually for each cell. So, they are not simple strings. I would to sum filtering by ...
1
vote
3answers
263 views

Excel 2002 won't activate

I installed Excel 2002 on my Windows 7 machine and activated it. I then uninstalled Excel 2002 and installed the Office 2010 trial to see if it's worth paying for the upgrade (I don't like it btw). I ...
1
vote
1answer
5k views

How to select radio buttons by cell value in Excel?

I have a group of radio buttons with labels in adjacent cells. How can I arrange for the radio button with the label matching a target cell value to activate? Here's an equivalent example to what ...