Tagged Questions

1
vote
0answers
28 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("=HYPERLINK("\\myserver\dir1\file.jpg", "Link") The problem: when clicked in Excel, this link ...
-2
votes
0answers
28 views

Rename the sheet name as User_User [closed]

Steps to Reproduce: Open a Worksheet Try to rename the Sheet1 as User_User (Success) Try to Rename the User_User Start with Spaces for User_User Actual: _ Symbol is carried with User_User, It ...
0
votes
0answers
28 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
0answers
109 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
92 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
78 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
240 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
62 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
184 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
65 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 ...
0
votes
1answer
170 views

How can I take a picture with the built-in web cam on my laptop Windows-7 & easily store it in a specific cell of a specific excel spreadsheet? [closed]

How can I take a picture with the built-in web cam on my Windows-7 laptop & easily store it in a specific cell of a specific excel spreadsheet?
3
votes
1answer
124 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
97 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
167 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
305 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
62 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
276 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 ...
2
votes
2answers
185 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 ...
0
votes
1answer
66 views

Copying and pasting in Word and Excel

I recently started having problem with pasting tables between Word documents and from Excel to Word. For some reasons it pastes table without frame, just disorganized text. It is very annoying because ...
1
vote
1answer
1k views

Why does my excel document have 960,000 empty rows?

I have an excel document, Office 2007, on a Windows 7 machine (if that part matters any, I'm not sure but just throwing it out there). It is a list of all employee phone numbers. If I need to generate ...
1
vote
0answers
190 views

File in use when it's really not

I am running Windows 7 Professional 32 bit on a Server 2008 network. I am getting a weird issue with an excel document where I open it up one morning, update it, save and close, the next morning I ...
6
votes
3answers
10k views

How do I force excel (and other office products) to stop opening files in the same application?

Whenever I "double click" on an Excel file and another Excel file is open, the newly opened file automatically opens in the same application window as the previously opened Excel file. This isn't ...
0
votes
1answer
262 views

Windows. Active X objects. Excel Chart

i need to find Excel active X object mschart.ocx or mschrt20.ocx. Where are they laying? Thanks! P.S: Am i right, that they can help me to use active x chart: msdn Thanks!
0
votes
1answer
247 views

Rows in Excel VBA Macros

I need help in being able to do the following: In Worksheet A I have raw data. In Worksheet B I have a template with formulas. The data on Worksheet A change on a weekly basis. I need to find a ...
1
vote
2answers
2k 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 ...
3
votes
3answers
4k views

Excel 2010 takes forever to open

I have identified a very interesting problem with Microsoft Excel 2010 on a client's computer. When opening an Excel file located on a shared folder or mapped network drive, Excel takes 2-3 minutes ...
1
vote
3answers
194 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
3answers
630 views

Hide cells when printing in Excel

I'm using Excel 2007. I have an estimate sheet, which I will use to keep track of client information. There is some low level information that the client shouldnt see on their version of the document. ...
2
votes
1answer
893 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

Right Click on Column or Row does not show Context Menu

I have the following issue: When right clicking in a row or column in Excel 2010 no menu is appearing. In Excel 2003 right clicking in a row lets you insert/delete rows. Do you know if this ...
0
votes
1answer
1k views

Rotating SmartArt or charts in MS PowerPoint or Excel

How do I rotate (90 degrees) a SmartArt Graphic or chart in Microsoft PowerPoint or Excel? I'm trying to show rotating spheres that when lined up, provide a topic for an intro, body and conclusion ...
2
votes
0answers
206 views

Activate Excel Add-Ins as part of Deployment?

I am using the office customization tool to create an unattended installation file for Microsoft Office 2010 pro plus. I have everything setup as I like, except that I need the excel add-ins activated ...
0
votes
0answers
127 views

Excel 2010 slow or hangs when doesn't have focus [duplicate]

Possible Duplicate: How do you keep Microsoft Excel running at full speed even when it does not have the window focus? Running Windows 7 with Office 2010. We are seeing a huge slowdown (4x ...
2
votes
1answer
798 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
3k 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 ...
4
votes
4answers
5k views

How can I force Excel 2007 on Windows 7 to always open another instance of the application?

I want to be able to compare to large spreadsheets side by side... Since you can not natively expand to all monitors I would like to have the two documents open in two instances. These files are ...
0
votes
0answers
597 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 ...
0
votes
1answer
124 views

Making a Chart like this?

I'm trying to make a chart like this: And my data is organized like this: I'm just not sure how my chart needs to be organized in terms of series to achieve this. Thanks
1
vote
1answer
6k views

How do I get embedded Excel files to open inside Internet Explorer?

Here's my problem: I have a web application that needs to open Excel files embedded into the web page. However, Internet Explorer (9 in this case, but the same goes for 8) only gives me the option to ...
0
votes
1answer
948 views

“excel stopped working” message on Windows 7?

We faced serious problem with Excel 2003. A message "excel stopped working" is displayed and excel just restarts. We start it with compatibility option for Windows XP, and I turned off user account ...
0
votes
0answers
282 views

“Browse in same windows” in Windows 7 [duplicate]

Possible Duplicate: Where is “Browse in same window” in Windows 7 Hello I have research on the internet for this solution since 3 days. But I can't find the solution. There is ...
2
votes
3answers
3k views

Running Excel 2007 as admin on Windows 7 causes “There was a problem sending the command to the program”

I am running Excel 2007 on Windows 7 64-bit. I need to run Excel as administrator so I have the "Run as Administrator" box in the Excel shortcut checked. Now, when I try to open an Excel file by ...
1
vote
1answer
5k views

Excel 'recently used list' not showing on start menu, but working within excel

In windows 7 when you pin Excel 2007 to the start menu, it usually has a small arrow which shows your recently opened documents. Mine only shows permanently pinned documents. It used to work until I ...
0
votes
1answer
4k views

Windows 7 (64-bit) compatibility of VBA/Excel and Access applications

I am currently investigating the possible issues when migrating from Windows XP 32bit to Windows 7 64-bit. The scope is MS Excel (32-bit), MS Access (32-bit) using VBA/Macros addins, ODBC and all ...
3
votes
3answers
2k views

Multiple versions of Excel

I'm running Windows 7 and Microsoft Office 2003, 2007, 2010 together. I would like to open all .xls files per default with Excel 2003 instead of Excel 2010. How do I do this on Windows 7?
1
vote
2answers
40 views

MS Excel 2007 ref

How to transfer data Row to Columns?
1
vote
2answers
128 views

Windows 7 computer cannot delete files from windows 2003 domain share

Computer running windows 7 pro connected to windows 2003 domain. User creates an xls file and he is trying to delete it. He deletes the file successfully and when he presses F5 to refresh the folder ...
1
vote
1answer
658 views

Excel document opens in IE 64, not in IE 32

Whenever I click on a hyperlink to a scrip that outputs an Excel 8 document, I get a prompt from IE to open the file or save-as. If I click open in IE 32 bit, the document opens in Excel (which is ...
2
votes
3answers
13k views

Where is “Browse in same window” in Windows 7

How in the world do you configure IE8 to NOT open excel documents in its window. There was a setting ("Browse in same window") in XP under Folder Options > File Types where you could specify the ...