Excel 2010 :: Inspect Document Doesn't Show Anything
Jun 30, 2014In my Excel 2010 workbook I wen through File > Info > Check for Issues > Inspect document. But as it's shown following, it doesn't show anything. Why?
Capture.jpg
ADVERTISEMENT
Excel VBA Combobox Doesn't Show List
Jul 24, 2014I created a user form in which i have a combo box. The combo box has the list
apple
orange
mango
So the combo box shows up the list only when something is typed on it ex:dot(.). i want to show the list by clicking on the down arrow of the combo.
Excel 2010 :: Add Password For PDF Created Through XLS Document
Mar 14, 2013How do I add a password to protect the PDF that I create from my excel 2010 document?
View 5 Replies View RelatedExcel 2010 :: Save As PDF - Document Not Saved
Apr 12, 2013I have an Excel 2010 spreadsheet which I need to print to PDF. There is a simple "Save as" PDF option which always fails with just the message "Document not saved". I created a simple test sheet with just a few numbers on to check it isn't due to complexities with the particular workbook. This works on my home PC (Windows 7) but not on the Windows 7 Club PC which is where I need to run it to generate the output which eventually will go to the club's website.
It also fails the same way if I try to create an XPS file (although I don't want an XPS file).
This fails from the normal user interface "Save As". I also tried it from a VBA macro and run it: I get Run-time error '-2147467261 (80004003)' Document not saved
I've googled endlessly but all the references I tried failed to uncover a solution. I was a bit surprised that this doesn't seem particularly common and most of the reports seem to be a couple of years old or older (no workarounds were useful).
Excel 2010 :: Sending Active Document Without Saving?
Mar 21, 2013I have a problem concerning sending an active word document via mail. I have a worksheet with various information in it, that I am exporting to a word document. I then want to send the word document via email. I want to do this without saving the changes in the word document. I am working with excel 2010. I have posted some of my code below.
VB:
Sub letter()
Dim myWord As New Word.Application
Dim adr As Variant
[Code]....
I get the following errormessage: "Compile error. Wrong number of arguments or invalid property assignment"
Excel 2010 :: Printing Multi-page Document?
Nov 23, 2011Have very recently been upgraded to Windows 7 with Excel 2010 at work. On printing out a 10 page doucment, (all of which are landscape format), when vewing print preview, the first page is previewed as landsacpe, but subsequent pages are portrait.
If you change format of 2nd page to landscape all subsequent pages switch to landscape.
Have looked at a similar format document created last month and it behaves exactly the same. Whole document landscape but on print preview only first page is...
Excel 2010 :: VBA Save AS (word Document) Not Working
Nov 8, 2012I have a long bit of code that at one point saves a Word document and then saves it again with a new name and the old (legacy) .doc extension.
This all works find when the user is running Office 2007. However, it errors out for using Office 2010. The reference libraries are all correct (as far as I know).
Code:
Dim myDoc As Word.Document
Dim saveAsName as String
saveAsName = "some text here" + ".doc"
myDoc.Save
myDoc.SaveAs fileName:=(saveAsName), FileFormat:=wdFormatDocument
Excel 2010 :: Password Protect Document At Administrator Level
Oct 2, 2012Excel 2010, Windows 7: Is it possible to password protect an Excel document at an "Administrator" or a executive level. I want to grant access to the document, and the ability to manipulate it as they choose, to everyone with the password but prohibit them from changing the password once they are in.
View 1 Replies View RelatedExcel 2010 :: Print Preview Doesn't Work Properly?
May 24, 2014First I made some contents and drew a border from Home > Font > all Borders on an Excel 2010 file. So it became like below image (capture1). After that I wanted to print it so went to File > Print to see its preview. But the problem is that the lines between tue and wed and also between mon and tue are not shown neither in preview nor when printing. The height of row 7 until 17 is 24 (that is 32 pixel) but heights of the rest of the rows are normal (20 pixel).
View 7 Replies View RelatedExcel 2007 :: VBA Code Doesn't Work In Outlook 2010
Jun 23, 2014My company recently upgraded everyone to Microsoft 2010 from 2007 version. I have no substantial VBA skill and left with a VBA code which is supposed to extract a list of outlook emails sitting in a shared mailbox into Excel.
I was using that VBA code in Outlook 2007 and it worked fine but shows the following error when run in Outlook 2010: 'Run-time error '-2147221233 (8004010f)': The attempted operation failed. An object could not be found. Here is part of the code:
[Code] .....
It worked after one of the members suggested to "click on any line of this code and press F8 repeatedly until the yellow focus moves to the error line, don't press F8 anymore. Now in immediate window, copy paste each of below lines, press enter after each line. Let us know where the error occur." However, it stop working the next day.
? olNS.Folders("Mailbox - Market Intelligence").Folders.Count
? olNS.Folders("Mailbox - Market Intelligence").Folders("Inbox").Items.Count
? olNS.Folders("Mailbox - Market Intelligence").Folders("Inbox").Folders("MI").Items.Count
Excel 2010 :: Intersection Of Named Ranges (same Worksheet) Doesn't Work?
Aug 19, 2013I'm trying to make a range selection in a pivot table as per the snapshot below:
http:[url],....
The values I am trying to select are the ones that are both red and italic. (Mobile, Other Fix, Fix) from CBU_NA.
I've searched and found a way to select both the rows for CBU_NA category and also the column categ2.
However when I try to make an intersection out of the 2 ranges I receive an error. I'm using Excel 2010 on windows 7.Below the code I am using:
Code:
Sub FCST()
Dim r1, r2, r3 As Range
r1 = pt.PivotFields("categ2").DataRange.Select
Selection.Font.Italic = True[code]...
Excel 2010 :: Dropdown Data Validation Menu Doesn't Work When Opened On Different Computer
Aug 19, 2013Using Excel 2010, I set up a simple workbook with a spreadsheet on one page and the ranges for data validation on another. I successfully linked the fields in the "Category" and "Tender" columns with the data on the second sheet, making nice drop down menus. Everything works fine on my computer. However, when we open the workbook on a different station, the drop down menus disappear. If you highlight any of the "Category" or "Tender" fields, the little drop down prompt is missing; they behave like regular, un-formatted fields. It appears that the data validation became un-linked.
We tried opening versions with certain fields locked (Mainly the Total, Breakdown, and Summary areas, but the fields with data validation were still editable), and also completely unlocked documents. Every time, the drop down lists were lost when opened on different stations.
I've attached the completely unlocked version : 00_FLEX TRAVEL EXPENSE REPORT_v3.xlsx
Forget to check a box or something? This seems way harder for me to figure out that it should be!
Excel 2010 :: Macro For Replacing Text In HTM Document - Text To Change Different Every Time
Mar 18, 2014I am my excel worksheet (excel 2010) I have one cell that changes every day (number). I want this number to open my htm document and replace the same number in a string in the htm and save/close this.
An example:
My htm document is located at C:/ and named XX.htm
The number I want from excel is in cell A1 in sheet1, and the worksheet is located in D:/ named yy.xlsx
And the text(number) I want to replace is in the following string in the htm document, in this string it is 72, next day it can be 30:
src="Bilder/72.png"
Excel 2010 :: Show Certain Image For Certain Value?
Mar 28, 2014I have this excel that look like this:
A1, B1, C1 contains an image with the numer 1, 2 and 3.
D1 is a cell where you can put only the number 1 2 and 3 (alert if you insert something else)
E1 have to contain the number in the D1 written with letters (I did this with the formula: =IF(D1=1;"One";IF(D1=2;"Two";IF(D1=3;"Three";"Wrong Imput")))
F1 have to contain the image from the A1, B1, C1 corresponding to the number in D1
Now, how do I do this ? I read an article here, on this forum, about doing this. I know how to copy an image from A1, B1, C1 in F1, but I don't know how to make a formula to do this.
To copy an image from A1, B1, C1 I do this:
- I copy the cell (F1)
- I hold Shift key
- I go to Start -> Paste -> Click the little arrow -> Last option (Translated from my language I think It's Linked Image) -> I switch the formula in that cell to =A1 or =B1 or =C1 -> The image appears.
I really want to know how to do that thing. I saw that you can not use an IF formula in the linked image cell so I need another option.
By the way, I attached the excel. If you will open it, go to Item2 Spreadsheet. I'm using Excel 2010 now.
Script That Will Turn Excel Document Into A Txt Document
Feb 17, 2009I need a script that will turn a excel doc into a txt doc. Thats the easy part. The hard part (at least I think it is), is I need it to be in a certain format and I'll do my best to explain that fomat below.
View 9 Replies View RelatedExcel 2010 :: Column Of All X Should Show In One Cell
May 7, 2013I have an array, say E6:E9. I have a single cell C6.
I want C6 to show an X, only if all E6:E9 have an X. If only E6 or E8 have X's, then C6 will remain empty. However if all E6:E9 all have X's, then C6 will display an X.
excel 2010
Excel 2010 :: Formula To Show Data Of More Than 3 Cell?
Aug 7, 2014(Excel 2010). I have 3 cell that contain data. What I need is to compare the 3 cell and return the data that has different value into 1 new cell.
I have attach an example : test.xlsx
Excel 2010 :: Making A Planning - To Show In A Report?
Dec 2, 2013I would like to make a planning, to show in a report. Is this possible to do with Excel 2010? Or do I need another programm?
View 2 Replies View RelatedExcel 2010 :: How To Show Number Of Items In A List
Feb 3, 2012The setup of my worksheet looks like this:
Excel 2010ABCDEFG1Tch grpTchr Split27B-MA5AWAWAWAWAWAW37B-MA4CB1,JDCB1,JDJD,CB1MMF,JDMMF,JDMMF,JD47B-MA3SXGSXGSZBSZBSZBSZBTchGrps
A great chance to use the HTML Maker for the first time!
What I would like to do here is show how many of each value there is in the range.
So for 7B-MA5, it would say 6. For 7B-MA4, it would be 2 / 1 / 3, since there are 3 unique values and their counts respectively. Finally for 7B-MA3 it would say 3 / 3
A formula option would be great but I'll also take a macro option since it is a macro that generates these lists in the first place, so I could just add the new code to the end of it.
Excel 2010 :: Not Show Blanks In Dropdown List With AutoFilter?
Jul 21, 2014How can I get the dropdown list to not include blank cells in the list reguardless if the sort filter is used or not.
Sheet 1 (STATS) is the dropdownlist Cell B12
Sheet 2 (Orders) is the data, I cant convert to tables because the cells are active and storted Column B2: is the data named.
so I have to use a formula to do this.
Using Excel 2010
See attached sample
Sample.xlsm
Excel 2010 :: Chart To Show All Of Amount Values For Each Size Value
Dec 12, 2011I am trying to create a chart that would show all of the Amount values for each Size value that is in the example data below. The Size column has fixed values. In my example the values are: .5, 1, 2, 5, 8, 13 and 21. The Amount column data is variable. Any of the static Size values can be associated with many Amount values. I was attempting to have the static Size values on the X (horizontal) axis and the Amount values on the Y (vertical) axis. I would like to have all of the Amount values for each Size value be shown directly above the corresponding size value, in one vertical line. See example below.
I an creating this type of chart in Excel 2010.
Note, I am still new to this forum and don't know how to post pictures or Excel data into my posts. I am also using dots (periods) to provide separation in my examples.
Amount...Size
58.5.......21
1........... 0.5
2........... 1
1.5.........1
27.5.......13
12.5.......5
2............1
3.5.........2
17.5.......8
4........... 2
48..........21
0.5.........0.5
15..........5
11..........2
Chart that I am trying to create. The chart example is not to scale.
...........60.|
...............|..........................................................................*(21,58.5)
Amount.50.|
...............|..........................................................................*(21,48)
...........40.|
[Code] ........
Excel 2010 :: Using Multiple Checkboxes To Hide And Show Specific Columns
May 12, 2014Basically I have a big table containing several columns for the different quarters. (Each quarter has several columns which are not all next to each other)
I would like to use 4 checkboxes which the user can select the show or hide the columns for that quarter. E.g. if Q1 and Q3 are checked only those are visible)
(if quarter 1 clicked than all columns are visible if unclicked hidden).
The code I have written workes well for the first checkbox (Q1), but for the other quarters (Q2, Q3 and Q4) the columns get hidden when checked (which should be the other way round) and don't get unhidden when unchecked.
Sub CheckboxQone()
If Range("$A$1").Value = True Then
Call showQ1
Else: Range("$A$1").Value = False
Call hideQ1
[Code] ...........
Excel 2010 :: Hyperlinks With JPG Files Using Internet Explorer Do Not Show Pictures On Win7
Jan 26, 2013In Excel 2007, Hyperlinks in cells pointing to jpg files in a subfolder display with internet explorer. On my WinXP/Intnernet Explorer 8/Office 2007 system these links work fine.
When sending the excel and jpg files to another person with Win7/Office 10, jpg hyperlinks work and launch Internet Explorer but come up blank. (Hyperlinks to PDF files work fine and show up in Acrobat, just the jpg's come up blank in Explorer.)
Questions:
What is causing this, a setting in Explorer/Win7 or Excel?
Can I change Excel hyperlink default software to use something other than Explorer to display the jpg files?
Excel 2010 :: Create Graph To Show Times Of Use For Particular Sporting Activities On Particular Days
Mar 20, 2014Excel 2010 - I need to create a graph that shows a week's use of a sportsground showing what sports were played, on which days and between which times. I thought I could show the times on the vertical axis, days on the horizontal axis and then the sports played in those times, however I'm unsure as to how to get the graph to recognise the times.
I've attached an example of some data and how I'd like to see it, I'm just not sure how I can do this using the chart set up!
Attached File : Graphs.xlsx
Excel 2010 :: Hide / Show Textboxes And Labels Based On Combobox Selection?
Jul 8, 2014I have created a UserForm that has a ComboBox and depending on the number selected I want it to show that number of Labels/TextBoxes...
So if I select "0" nothing is shown, if I select "1" one set of Labels/TextBoxes is shown, select "2" and two sets of Labels/TextBoxes are shown... but also if I have selected "2" and then select "1" I want the second set to be hidden again...
Also I know I should have renamed the Label/TexBoxes to make it easer but I was adding things and making it up as I went along...
I'm using Excel 2010 on windows 7.
Code:
Sub UnHide_NewRoutings()
If (Engineering.ComboBox2.value) = "0" Then
Engineering.Label4.Visible = False
Engineering.TextBox5.Visible = False
Engineering.Label9.Visible = False
Engineering.TextBox9.Visible = False
[Code] ..........
Excel 2010 :: Check If Cell Not Blank Upon Saving Or Closing And Color Code To Show Blanks
Aug 30, 2012Looking forward VBA coding for:
If input is entered into column C (range C2:C100), then row cells for columns D, E ,F, H or I must NOT be blank upon save.
Could be that one or more of these row cells are left blank by mistake.
An error msg pops up upon attempting to save, stops the save and colors each cell yellow that needs info entered into.
Using Excel 2010.
Getting Symbols To Show Up As Numbers In Linked Document.
Oct 8, 2008I have a linked document, only 2 sheets. On the first sheet there is a column for + or - signs, I need a formula for the second sheet to show the + as a 6 and the - as a 5 instead of just the symbols carrying over.
View 3 Replies View RelatedFormula Doesn't Show The Date...
Jan 26, 2010I m writing this formula in a cell but i dont receive the result i want...
Formula used... ="Program "&""&G2
(G2 is a Date)
This is te result i get...Program 40210
This is the result i want...Program 1-Feb-2010
Dir Function Doesn't Show Files?
Apr 17, 2013I am trying to write Excel VBA on Mac. Need to use the Dir function to get the file name in my document folder, but it showed only one file in the folder "DS_Store". There are actually several Excel files in the directory just don't show up by using this function. I have done some research on this "DS_Store" file, it seems a hidden/system file for Mac. It's fine, but it really doesn't make sense that other files won't show. Also, when writing VBA for Windows, *.xls refers to any file with a .xls extension. How to express the same thing for Mac? I am new with Mac, it just works so different than Windows.
View 9 Replies View RelatedUserform Data Doesn't Show In TextBoxes On Another Sheet
Feb 23, 2012I have a workbook with 3 sheets.
Sheet 1 is a sheet that has a shape with macro assigned to show Userform6.
Sheet 2 contains data that is displayed on Userform6. I use Userform6 to show statistical data that is on Sheet2.
Sheet 3 contains data that is input to ComboBoxes on Userform6 using the RowSource Property.
On Sheet 2, when I select Userform6, the data is correctly shown in all comboboxes and Textboxes......
On Sheet 1 when I select Userform6, only the comboboxes show the data...the textboxes do not show any data.
I do not want users to see the data on Sheet 2 which is why I want to show the Userform on a different sheet as the data sheet will be hidden from users.
Question is: How can I show Userform6 on Sheet 1 with all the data showing in textboxes?