0
votes
2answers
32 views

How to add minutes in a column?

I have a call activity .csv file downloaded from my vonage account and I wanted to add up all the minutes in a column. I know how to add numbers but not sure how can I do it for minutes. Date/Time ...
1
vote
2answers
101 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 ...
1
vote
0answers
51 views

Weird Excel 2010 VBA Window Behaviour

If I open Excel and then open the VBA window then close it, every time I RDP to my computer, the VBA window is open again, even if I closed it before disconnecting. The next time I am sat locally to ...
0
votes
1answer
30 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
48 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
54 views

Convert OO4 ODS to XLSX using Excel 2010 VBA

I am trying to bulk convert OpenOffice documents to Microsoft Office. Using built-in VBA, I use the following code (ODS to XLSX is shown, but same code is being used for ODT and ODP with some ...
0
votes
2answers
1k views

Excel 2010 - How to quickly add multiple hyperlinks to different cells

I have an Excel document in which I have to add multiple folder hyperlinks. The problem is that I have more than a thousand rows, and doing it manually will take ages. In each row, cell B will ...
0
votes
0answers
41 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 ...
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
44 views

Word converting linked excel objects to text table when updating

I have several Excel tables that I have embedded as linked objects in a Word file. They look great for the monthly report. However, when I go to update the Word doc the following month with updated ...
0
votes
0answers
19 views

How can I make vertical error bars in Excel 2010? Windows 7

How can I make vertical error bars in Excel 2010? I have gone to the more errors bar option, but I only have the option to select horizontal bars. Thanks
2
votes
1answer
353 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
3answers
667 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
2answers
103 views

Is there a way to compare two tabs of data and place Difference at end of one of the datasets

I need to find a way to compare two spreadsheets and if there is a Differences, pull data from one sheet to the other. Sheet1 has a list of all Dealers in my Zone. Other Tabs in my workbook have ...
0
votes
0answers
52 views

Freeze Panes Excel 2010

How Can I maintain the freezed first top rows in an excel 2010 spread sheet when I open the document a second time? I already know and have tried to freeze the first couple of rows, but when I save ...
3
votes
1answer
337 views

How can I easily split a CSV into two Excel worksheets with PowerShell?

I recently found out that PowerShell can be used to write Excel documents. The first use I thought of for this was to (at least partially) automate parsing of some CSV reports that I regularly have to ...
4
votes
2answers
75 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 ...
0
votes
2answers
300 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
3answers
33 views

Tie cell content to comment box in another cell

I would like to show content of a cell (currently text string) as a comment in another cell. Also, is it possible that such connection would update itself should the test content change ? Cell ...
0
votes
1answer
49 views

Finding specific column heading and filling table from that column

I have a problem which I've actually managed to solve but I'm currently using around 60 IF-statements which seems ridiculously inefficient. Two workbooks have the same table in them (see pictures ...
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 ...
-1
votes
1answer
652 views

How do I remove multiple page breaks between rows in excel 2010?

Multiple page breaks appeared between each row and column on an excel 2010 spreadsheet. How can they be removed?
1
vote
1answer
3k views

How do I transfer Excel from one computer to another w/o installation CD?

I have Microsoft Excel 2010 on an old computer, and want to transfer it over to a new one, but I don't have the installation CD. I'm on Windows 7 32 bit. I found the exe in Program Files > Microsoft ...
-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 ...
0
votes
1answer
134 views

Why isn't Digit Grouping working in Excel 2010 as defined in Regional & Language Setting?

Just upgraded to Excel 2010 & Windows7. Digit grouping setting defined as required (12,34,56,789) in control panel>region & Language>Addl Setting>Digit Grouping, but Excel is not ...
0
votes
0answers
136 views

Paper size in paper setup of Excel 2010 grayed out

i have a workstation with a network printer installed that i use to RDP to another machine. while the printer works fine on the host, within the RDP session the redirected printer seems to gray out ...
0
votes
0answers
566 views

Is there Windows 7 Run as Administrator fix for Outlook?

I have excel 2010 report which has a script that runs automatically emails report via outlook 2010 but it will only work if I have Outlook open via right click and Run as Administrator. Is there a ...
2
votes
1answer
934 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 ...
1
vote
2answers
263 views

Excel 2010 hangs on launch even after removing both XLSTART folders

On Windows 7 Professional SP1 32-bit on a Lenovo Core i5 laptop with 2 GB RAM, Excel 2010 is suddenly hanging on launch. It opens fine in safe mode. Office 2010 shows version 14.0.6029.1000. Very ...
2
votes
2answers
12k views

How to reset Excel 2010 settings to Default?

Excel's cells are very small when at 100% zoom (see screenshot below): I have searched Excel's menu but couldn't find anything relevant. I tried to install Microsoft Fixit but it said it wasn't ...
0
votes
1answer
428 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
0answers
2k views

Where is my personal macro workbook? [duplicate]

I typed in the path as instructed below but my computer couldn't find my personal macro workbook. What am I doing wrong? In Excel 2010, the personal macro workbook is located at: ...
0
votes
1answer
46 views

Keyboard default binding to advance to next sheet in Windows Excel 2010?

Using the default bindings for Microsoft Excel 2010 on Windows 7, what keyboard binding exists (if any) that allows me to navigate to the next sheet in a spreadsheet? What about the prior sheet? ...
3
votes
1answer
358 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
186 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
235 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
529 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 ...
1
vote
1answer
51 views

I have prefixed a text no. in an Excel column, but after the all number formatting is changed, how do I get the numbers along with the added text? [closed]

Example: Originally it was (as text format ) 23456789. After adding text it read as RNE1.2012E+11 but if I format using format cells only numbers are restored.
2
votes
1answer
593 views

How can I change what cell is selected after I press Enter in Excel?

Is there an Excel keyboard shortcut for changing editing , i.e., for "After pressing Enter, move Selection Direction (to) Right/Down"?
1
vote
2answers
5k views

Very infrequent Excel crash

Have 1 user who keeps experiencing an Excel crash when sorting data. It is very infrequent and as of yet i've not done any serious troubleshooting, just an Office repair. Event log reports the ...
2
votes
1answer
4k views

How change the default font for comments in Windows 7 + Excel 2010

In Windows XP + Excel 2007 one could change the default font for comments in Excel with: right-click on desktop, properties, appearance, advanced, tooltip, enter size. But I could not find this ...
2
votes
1answer
3k views

Export Excel settings to a file

I have customized Ms Excel to my needs, for example I have written small macros and attached them as buttons to the quick access toolbar, made the Developer tab visible etc.) Is there any way to ...
2
votes
1answer
1k views

How do I disable multithreaded calculation in Excel 2010 - as a permanent setting (without needing to set it on a worksheet)

I need to be able to have excel 2010 open (in windows 7 if it makes a difference) and have this setting defaulted to off. I've tried unchecking the box and closing excel, saving the setting on the ...
1
vote
0answers
5k views

Windows 7 can't open Excel 2010 .xlsm files?

I just reinstalled Windows 7. When I installed Office 2010 I deselected some components to save disk space. Now, I can't open xlsm files. I would like to know which components in the Office ...
0
votes
1answer
2k views

Export excel file to textpad each cell delimited by '|'

MS Excel export allows a csv (comma delimited) export. Is it possible to export my files from excel to .txt or csv files (all the cells in my excel file) delimited by "|" (without the quotes) instead ...
0
votes
0answers
882 views

What might cause Office 2010 Excel to crash when pasting from Access

I'm using Windows 7 and Office 2010 on a new machine so both are fairly new installations and have been fully updated. For the most part things with office have been fine, but when trying to work on ...