0
votes
1answer
38 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
37 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
737 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
48 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 ...
0
votes
1answer
38 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
8 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
19 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
40 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
70 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
58 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
50 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
30 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
43 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
48 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
35 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
101 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
58 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
59 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
28 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
141 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
127 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
241 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
83 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
329 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
252 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
35 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
69 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
42 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
405 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
80 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
49 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. ...
0
votes
1answer
385 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
172 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
84 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
165 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
38 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
46 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
927 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
486 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
288 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
29 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
207 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 ...
0
votes
0answers
204 views

Export to excel not working if ms office is not present on machine

You might think this can be a possible duplicate to questions like this: How to create excel file witout installing MS Excel in vb.net? However this is not the case, I've googled a lot and things are ...
0
votes
2answers
30 views

Convert folder of word docs into a single, parseable spreadsheet

Is it possible to show MSWord a folder full of .docs or .docxs and have it convert them into a spreadsheet containing columns for different variables that describe each document, such as filename, ...
0
votes
1answer
208 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 ...
0
votes
2answers
206 views

How to set character per line limit in word or excel or any other program?

I'm doing an application online and part of a section requires 7 lines of writing. However in each line it requires no more than 130 characters. I have done the 7 lines but some lines are over 130 ...
0
votes
0answers
61 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
1answer
169 views

Access Database engine Issue

I have recently moved from 32 bit to 64 bit version PC which runs 32 bit version of Office package. I have an application (.net 4.0) which handle excel files and which uses the ...