1
vote
0answers
12 views

Why does Excel 2013 Ignore My Keystrokes?

So I was doing some copying and pasting into this new Excel file, and all of a sudden the keyboard is not being recognized in Excel. I also am unable to save this file. Anyone have ideas? Here is a ...
0
votes
1answer
23 views

How to replicate an anchor tag in Excel

I have an Excel (csv) like this: column1 link yahoo <a href="www.yahoo.com">Yahoo</a> google <a href="www.google.com">Google</a> Is there any way to make link ...
1
vote
1answer
26 views

No Startup folder in Microsoft Office for Mac 2011

I'm trying to save a new default worksheet in Excel for Mac 2011. Instructions say to save it in the Startup folder at this location: /Applications/Microsoft Office 2011/Office/Startup/Excel There ...
1
vote
3answers
21 views

prevent excel formatting as number

I have to copy from SQL Server Management Studio often. Many of our ID column fields are filled with numbers but have the data type varchar. When copying output from SSMS to Excel MSOffice determines ...
1
vote
3answers
98 views

Microsoft Office 2010 Excel will not open two xls

I am using Windows 7 and Windows 8 and I see the following behavior with Microsoft Office 2010. Create two Excel files, say a.xls and b.xls Open a.xls by double clicking it. After the file is ...
2
votes
1answer
27 views

Pivot table with two headers in MS Excel

I'd soo appreciate if someone could help. My initial table looks like this: Brand Period_1 Period_1 Period_2 Period_2 ------------------------------------------------------ ...
0
votes
1answer
91 views

How can I disable changes to folder last modified date?

When I open an excel file, for some reason the last modified date of the containing folder changes to the current time-stamp. I want to disable this, it causes lots of confusion, especially when I ...
1
vote
0answers
47 views

MS Excel 2013 Basic Help, While Offline, Not Responding

Until about a week ago I could get basic help in Excel 2013. I could search for something like "text functions" and got links to those pages. Now I get no response at all after pressing enter or the ...
8
votes
1answer
898 views

How do I stop the excel file being in use? [duplicate]

I'm opening an Excel file and I'm getting the File in use pop-up that says it's locked for editing by me. However, I've not got it open on this computer (I think I had it open and my machine ...
0
votes
2answers
72 views

How to sort columns in Excel so that only one value appears in each row?

Say I have a a spreadsheet with the following data: A B C D --------------------- 2 1 0 2 3 2 1 4 5 3 3 6 7 5 6 8 11 8 10 10 ...
1
vote
1answer
76 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 ...
0
votes
0answers
10 views

Excel group files not opening

The OS is Windows XP 2003 server and the program is Microsoft Office Standard 2007 (Excel). This computer recently upgraded from Office 2003 to Office 2007. Upon clicking any .xls or .xlsx book file ...
0
votes
0answers
20 views

Excel or Google Sheets - How to update smoe columns

I'm working with some back-end software that generates a work queue for our purchasing department. The work queue is a spreadsheet that looks like: ...
0
votes
1answer
61 views

Autofill in Excel skipping rows

I am trying to accomplish something with excel but I cannot seem to make it work. In a worksheet I have a simple table with rows and columns. Every row is a new entry. I then have a template in ...
0
votes
0answers
127 views

After ignoring DDE function, cannot open separate instances of Excel [duplicate]

I looked up a method of opening multiple files in separate instances of MS Excel, as I have both a landscape oriented and portrait oriented monitor and need to use both. The common method of doing so ...
0
votes
0answers
67 views

Embedded excel chart in powerpoint does not print correctly from Office 2013

We have a user that has Office 2013 installed in her machine - she is the only one. The rest of the users have Office 2010. The user with 2013 is the only one with the issue. There is a powerpoint ...
0
votes
2answers
56 views

Explanation of the dollar sign

When referring to a cell, what is the difference between these? A1 A$1 $A1 $A$1 For my situation, I need a formula that says "when A equals 8" but more importantly the difference between each of ...
0
votes
0answers
43 views

Excel 2D-lookup on a PivotTable with changing coloumns and rows

I want to do a Vlookup on a 2D pivot table but neither the coloumns and rows of the pivot are fixed and are subject to change due to ever changing data source. How can I perform a accurate vlookup on ...
0
votes
2answers
53 views

How to perform sql query on sheets of excel

I have two tables in excel(sheets) . One has 10,000 entries , another has 1000 entries . Both of them have account number column in common . I want to select only those row in 10,000 entries which ...
0
votes
1answer
60 views

Microsoft Excel Custom Label Overlay on Line Graph

I have 2 tables identical. One records the progression of projects as a percentage over dates until completion. The other is a replica table but records the daily status of the projects on the ...
1
vote
1answer
43 views

How do I search for an actual asterisk in Excel?

I want to search for and replace "*", an actual Shift + 8 asterisk.There is no option to turn wildcards on and off like there is in Word.
0
votes
1answer
170 views

Where can I find my office account email for office 365

I purchased office 365. In order to install on my computer I had to log in with email so I quickly made an email. The package I purchased allowed for install on five computers. But when I try to ...
1
vote
1answer
214 views

PowerView to PowerPoint?

Is there a way to export PowerView slides/tabs to PowerPoint? I realize there are a couple articles on how to export PowerView from Sharepoint, but wondering if there is a way to do this for ...
-2
votes
1answer
78 views

Microsoft office automation error

I am receiving an error when i try to create an excel workbook through a vb6 application. the error is a Microsoft Software Installer error 0x80004023. i have read over a similar question on a ...
0
votes
0answers
33 views

Excel 2003 Issue: Row Height Issue After Autofiltering

I'm using Excel 2003 right now, and have constructed a spreadsheet that features merged and unmerged, multiple cells in each row. Each cell, merged and unmerged, has their row height manually ...
1
vote
2answers
329 views

Importing an XML file into excel

I have a multilevel XML file. When I import the XML into excel, it creates multiple columns for the multilevel data. However, I need the multilevel data as additional rows. Is there any way I can ...
1
vote
1answer
292 views

Excel 2007 or 2010 copy/paste without merging cells & with shift all down

Let say I have an excel sheet with structure like I select a few cells (at one column) and click Ctrl+C. After that I want to paste it. I select one cell(B116): And click Ctrl+V. It gives me ...
-4
votes
2answers
446 views

want a macro to automate and copy paste value from excel and paste in website [closed]

I work in the automotive industry and a part of my job is that I need to check if the vehicles are registered in the company website. Everyday I am provided with a list of hundreds of chassis numbers ...
0
votes
1answer
96 views

Office 2013 programs hang when alt key is pressed

I am using Office 2013 on a Dell Windows 8 laptop. When I press the ALT key in either Word or Excel the document I am editing will immediately hang (e.g. trying to do Alt-tab, Alt-F, etc). Other ...
-4
votes
2answers
518 views

Custom Data Validation in Excel 2010 [closed]

I'm trying to make error messages appear when someone tries to enter the wrong data type in a certain cell with data validation in Excel 2010. Is there a feature or some sort of formula I can use? ...
0
votes
0answers
348 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
2answers
39 views

Excel: Applying Condittional formatting to every other row

I would like to apply a specific conditional format to every second row in my spreadsheet. In my specific case I have regression results, where the first row indicates the beta coefficient and the ...
0
votes
0answers
89 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, ...
1
vote
2answers
46 views

conditional formatting excel 2013

Is there a way to highlight a cell (possibly with conditional formatting) if one of the cells to the left of it has data, but it is empty? for instance, A B C D ...
1
vote
0answers
586 views

Office 2013 can't open office 2010 protected file,vice versa

I couldn't achieve to produce an interchangeable protected file between Excel 2013 and Excel 2010. Excel 2010 can't open 2013s protected one and 2013 can't open 2010s protected one. I think their ...
2
votes
1answer
82 views

Excel 2013 table formatting

I currently have a table that looks like this: Company | 2013 Total | 2013 Gross $'s | 2013 Gross % | 2012 Total | etc.. | | | | | ...
0
votes
1answer
51 views

excel - if value grater than, use that value

I am having problems with my excel function. I want to: if value 1 is greater than value 2, then write value 1 in a cell. If value 2 is greater than value 1, then write value 2 in the cell. ...
1
vote
2answers
601 views

How do I prevent Excel from changing the color of a clicked link?

I'm using Excel 2010. And as most Excel users know, if a cell is also a link, once you click it it turns to this awful purple color. For me this ruins the color coding I'm using to show the status ...
3
votes
2answers
254 views

Setting default editor language in word 2007

I want to change my default editing language in word as English (India). It is not so possible to change the language setting in all users and all PCs manually. Manually we can change the default ...
0
votes
1answer
97 views

How to copy/paste a Word a file that has a linked formatted text?

I link some datas in a word file in order to have dynamic fields. I do it by this way I add a Text field from Under Developers - Controls - Text. I write something to this text field and copy it ...
0
votes
1answer
203 views

Create excel checkbox and lock other cells in the same row WITHOUT using macros

I'm trying to find out if it's possible to avoid macros to do the following: when the user ticks a checkbox, it locks all other cells from the same row. If he unticks, it unlocks the cells... At this ...
0
votes
0answers
41 views

Force PowerPoint to open a new Excel instance

When using the insert diagram function in PowerPoint, PowerPoint automatically opens a new Excel window. Unfortunately, if you already have an Excel workbook open, it will simply use the same Excel ...
0
votes
1answer
52 views

Set Excel 2010 file format in the registry

If you install MS Office (2010 in my case) and run up any of the programs (Excel in my case) for the first time you encounter the following dialogs: The Username dialog for setting a default user ...
0
votes
0answers
1k views

Can't choose “rows to repeat at the top” in excel page setup menu

I purchased a brother dcp-8150 printer and now when i'm in office 2007 excel file my "rows to repeat at the top" option in page setup cannot be highlighted. Can you help
4
votes
2answers
629 views

Using English macros in French version Excel

I am currently in France and am using a computer on which all Office programs are in French. I need to use a Macro which has been written in English VBA, but it fails. I assume the issue a language ...
0
votes
1answer
2k views

How do I automatically sync/couple an Excel file to Onedrive on Mac OS X?

I know how to save a file on Onedrive and it all works fine. But I would like to couple an Excel-file on my computer (or elsewhere) to Onedrive. That is: I work on a file in Excel and when I save that ...
0
votes
1answer
404 views

How do I get ALT-ENTER wordwrap to auto-fit the height the cell EXCEL?

I am using ALT-ENTER for hard word wrapping in a cell. However, when I use it, the autofit height doesn't work properly. It fits the height of the cell to the first line. Is there any solutions to ...
0
votes
1answer
32 views

Conditional Formatting with Office 2008 for Mac

I'm working with a 2,000 line spreadsheet in which I want to isolate certain lines based upon certain key words in descriptions contained in the 1st column. I have tried using Conditional Formatting ...
1
vote
1answer
22 views

Excel 2010 switching to formula view after every click

Since I installed Excel 2010 64-bit (was using 32-bit version before), every time I click on an icon in one of the ribbons, e.g. reducing icon size: The top bar switches to the formula view: ...
0
votes
1answer
286 views

Generate ordered numeric list in Excel based on cell value

I'm not sure if this is possible, but I would like to create an ordered numeric list automatically based on a cell value. For example, if I have a cell with a value of 100, I want excel to ...