0
votes
0answers
54 views

Excel: Timeline for Pivot Table based on XML imported data in Office 2010?

I imported XML data into Excel document on Sheet 1. Added Pivot Table based on that data to Sheet 4. Then I made a chart based on that Pivot Table. Is there any way to create a timeline just like in ...
0
votes
0answers
25 views

Office 2010 user defined Color theme as default

I have created a new colour theme that represents our companies standard colours and want to define it as the default. The default colour theme is Office. How do I define my company theme as the ...
1
vote
1answer
920 views

Outlook attachment opening issue when Excel configured to open in new window?

I was tired of Excel opening additional documents within the same instance, so I looked into how to force it to open a new instance for each file. This answer worked great. However, I then got an ...
0
votes
1answer
150 views

How to select all empty cells below current selected until first non-empty cell in VBA

I am trying to write a macro that copies the current cell and pastes the text into every empty cell below it until it reaches the first non-empty cell. So if I had "Apple" in cell B2 and "Orange" in ...
0
votes
2answers
407 views

If / Else logic involving text i Excel

I want to perform the following logic in a Microsoft Excel 2010 worksheet: In cell E3: if C3 = Off or off then VALUE=0, else Value=C3*D3 Where cell C3 will contain either a number or the word 'off' ...
0
votes
1answer
417 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 ...
4
votes
1answer
3k views

Why does Office 2010 fail to open an Excel file?

I have a excel file I've put on a file server. When required i access it via a dll, fill it with some data in background only (through ExecuteExcel functionality). It used to work before. Recently I ...
3
votes
2answers
13k views

How do I bring back the ribbon in Office 2010?

The ribbon in Excel 2010 appears when I click on Home or Insert or one of the other tabs, but disappears again when I go back to editing my document. I'd like it to always be visible - how can I get ...
1
vote
0answers
124 views

Select and delete form controls without using the mouse in Excel

I have some 0px width checkboxes in my Excel 2010 document and I can not select them by mouse. I need to delete them. Is there a way to select them not using the mouse? Is there some list of all used ...
1
vote
0answers
266 views

Is there anyway to co-author with the Excel 2010 Desktop App?

I'm wondering if there is clean way to co-author with the Excel 2010 desktop App? Now, or possibly this could be a placeholder for the future. The current answer seems to be no with Excel 2010 desktop ...
2
votes
2answers
1k views

Office 2010 prompts for login to SharePoint when editing local documents

I have MS Office 2010 installed and we have intranet sites using SharePoint 2007 and 2010. When I open a document from my hard drive or create a new document in Word or Excel, I get a prompt to login ...
1
vote
1answer
310 views

Excel 2010: Home tab is blank

A user on our network has somehow managed to empty out their home tab in Excel. I've not had much luck finding a fix on Google. Does anyone have any ideas how to fix this? The tab cannot be ...
1
vote
1answer
582 views

Office 2010 and save issues

Since I installed office 2010 I can't save an Excel file that I used under Excel 2003. what to do?