Unable To Print Excel File?
Aug 12, 2013I am unable to print an office file to a certain printer because I am not the author of the file.. when I copy and paste to a new doc I can print no problem.
View 1 Replies
ADVERTISEMENT
Unable To Open Excel File
Oct 12, 2013I was able to open and read this file before installing Windows 8.
The background to this is that after installing Windows 8 and reinstalling Windows University 2010 my word documents and excel files where all opening up as word pad documents. I figured out the solution to the above on my own and I am now able to properly read the excel and word documents that I tested. But I am not able to read a very important excel file. It is very important that I restore somehow this file.
When I open the excel file a dialogue box open up saying "Excel found unreadable content in "Account.xlsx". Do you want to recover the content of this workbook? When I choose Yes the following dialogue box opens up saying "Excel cannot open the file "Account.xlsx" because the file format or file extension is not valid. Verify that the file has not been corrupted and that the extension matches the format of the file".
The file extension is set to xlsx however how do I test to see if it is corrupt. Is there anything I can do to restore this excel workbook?
Excel 2007 :: Unable To Save As PDF File
Apr 26, 2013I have an Excel worksheet (2007 version) which I am trying to save as a PDF file. However, the PDF option is not listed in my "Save as type" drop down window.
View 3 Replies View RelatedConvert Excel WB To Pdf File And Print - VBA
Sep 23, 2004I want to put an Excel workbook to pdf format and print it out at the click of a button located in the book. However, when I try to record the macro to get a feel for how to control pdf with Excel, I get a pdf file but no printout and no code to veiw!
View 9 Replies View RelatedExcel 2010 :: Print Area Changes On Same File Between 2 Different Computers?
Jun 6, 2013I have a technician who sits a desk over, has the same brand of computer running the same Windows 7 and the same Excel 2010, but when he opens a particular file the page layout or print area seems to change so that the sheet is partially cut off. All his options appear the same. I can open this file on other computers and it seems to be fine...
I notice that the Margins under Custom Margins are different and this would explain the problem but not why it occurs. It's a file I created and saved and he opened. Why would the margins change? Is this one of the Microsoft cross platform / program deals where if he changes the print set-up or page layout in WORD for example, it changes them in EXCEL?
Excel 2010 :: How To Make Macro Print In Other File
Jun 26, 2014Excel 2010.I'm using this code to print user's accessing a file:
[Code] .....
However as someone could just delete the printed user log in the Sheet2, and also you can't use this if you protect the sheet, which defeats the purpose.
I want it to print the log into a separate file. Can I add in the file path/name to this code somewhere?
Excel 2010 :: Setting Up File To Print - Cannot Reopen It
Apr 17, 2013In Excel 2010 I was working on a file setting it up to print. The file closed somehow and I just cannot reopen it. There are other files in the same folder and they all open normally.
View 4 Replies View RelatedFile Print In Legal Size If I Have 56 Lines Filled In Then Print In Regular Letter Si
Oct 15, 2005I am trying to have a file print in legal size if I have 56 lines filled in
otherwise print in regular letter size. Does anyone know how to write this
in VBA.
Unable To Open XLS File Without Password?
Feb 5, 2013I have a certain .xls file which is password protected.
Now i have forgot the password for opening the file. Is there any other way of opening the file without password or using a Macro.
Unable To Convert File Types?
Dec 11, 2013I am having trouble converting file formats. I would like to convert a.xlsx file to a .xls file. It is password protected and everything I have tried to use to convert the file has failed.
View 5 Replies View RelatedUnable To Break Links To Another File
May 8, 2006Last week I copied a worksheet from one spreadsheet into another, and have since been working from the new one. When I open the file I get a message box asking if I want to Update links from the other workbook. But I've deleted all named ranges, formulae, shapes, everything that could possibly link to the other workbook. I've also (in my frustration) completely deleted the sheet that was originally copied and re-made it from scratch. But it STILL comes up with this update box. In Excel's Help it says to go to Edit/Links and press Break Link, which I have tried but it doesn't do a thing. The link is still sitting there in the display box in the Links window - it says that the Type is Worksheet, I don't know if this makes any difference that it's not a formula or anything?
Also, in complete desperation when it wasn't deleting the link, I changed the source to a random file, so it now comes up with an error in updating (which it obviously would) however this doesn't have any effect on my file because as far as I can tell it no longer has links to the other file! I'm tempted to just go to the option that says don't show the Update prompt on opening (the file is to be handed in as coursework on Wednesday) but this doesn't solve the problem, only bypasses it! Each time I made a major change (e.g. recreating the copied worksheet, changing the source) I saved the file under a different name, so I have all old copies just incase I've completely messed it up!
Unable To Open Multiple File And Run Macros In It
Dec 20, 2013I am facing an issue where my macro is unable to open multiple files and run the macros in it. Below is the code that i am using and it stops at boss1.
VB:
Sub allboss()
Call boss1
Call boss2
End Sub
[Code] .....
Excel 2007 :: Content Shown On Worksheet Different Than Print Preview And Print?
Jul 17, 2014Since upgrading to Windows 2007 (I was already using Excel 2007) I am having issues with the content in the cells on the worksheet not appearing the same on Print Preview and when I print. On the worksheet the cell show to be at the best fit both horizontally and vertically. When I look at the contents under print preview, the contents are squashed from the top and cut off from the left. This happens whether I have the format in Top or Central align and is even worse if I use Bottom align. It is also somewhat worse if I have thickened boarders.
I am using TrueType Fonts.
Excel 2010 :: How To Apply Print Titles To Print On Select Pages
Dec 10, 2012Using Excel 2010: I have 2 rows (A4:J4 & A5:J5) selected as print titles that I would like to be printed at the top of selected pages. Currently, my document is 3 pages long, and I would like to have the print titles only applied to the first 2 pages. More data will be added in the future on pages 1&2 but the last page (whatever page number it ends up being) should not contain the selected print titles.
View 2 Replies View RelatedRuntime Error 1004 - Unable To Save File
Mar 30, 2014I am executing code in a workbook that has been working successfully previously.
Suddenly I get a run time 1004 error in any macro in the workbook that tries to execute a activeworkbook.save command?
Unable To Graph Excel Data?
Feb 9, 2014I am trying to graph the amount of calls that come in on each day and at what hour. I am trying to put the days of the month along the x axis and hours along the y axis. I then want the number of calls to show as a scatter at certain times on each day. Is this possible? I have attached a sample of a table I will be working with that has made up data on it. I have tried using the select data function to try and change the axis, but I do not think I am writing the correct things in.
View 4 Replies View RelatedExcel 2010 :: Unable To Cut Columns?
Jul 25, 2013I could swear I used to be able to cut and paste columns in Excel 2010, but for the past week I haven't been able to. When I click on a column and do a right click, "CUT" is greyed out. I can cut any section, but not a whole column.
View 3 Replies View RelatedExcel 2010 :: Unable To Delete Rows
May 30, 2014I'm on mac Excel 2010 and i'm trying to delete rows..but for some reason they don't go! My workbook is a basic one, just filled with a bunch of formulas, i can't understand why it wont let me delete it.
When i do try to delete it, nothing comes happens and when i try to delete a large amount it comes up with 'not enough memory, continue without undo deleting rows' but my laptop has 8GB and my other laptop has 16GB so i can't see why a 16GB laptop wouldn't be able to delete it.
Excel 2013 :: Unable To Customize Ribbon
Jul 14, 2014I have been attempting to enable the developer tab in Excel 2013, and have been unable to do so. When I check the box for the Developer tab, then click OK, the ribbon flickers, as if the tab is being added, but then the tab does not appear. When I go back to customize the ribbon, the check for the Developer tab is again not checked. I have also tried to move things around to different tabs and none of the changes stick.
View 9 Replies View RelatedExcel 2007 :: Unable To Search The Last Column?
Jul 28, 2013I've to continue the same sheet made by my bos (I'm using excell 2003, my bos use 2007). However, I'm unable to find the next column which my bos used it. Ex : My last column in excel is IV column. However, my bos's column in more than IV column.
View 2 Replies View RelatedExcel 2010 :: Unable To Set Column-width?
Oct 5, 2012From one moment to another I am not able to set the column width doing the following: right-mouse-button click (the column) and choose column width and then type in the desired width The column width is not set this way.
Setting the column width by dragging the right side of the column works well. Also double clicking the right side of the column (auto width) works fine.
I think I have pressed a certain key combination (I am not aware of) to activate this behavior.
How can I re-activate/enable the above (1st) mentioned method to change the column width?
Unable To Access RPT Files In Excel Macro
Dec 7, 2012I am not able to access *.rpt files in excel macro
By using this below mentioned codes am not able to open the files from folder.
Code:
fpath = "C:Documents and Settings est"
f = Dir(fpath & "*.xls")
Workbooks.Open Filename:=fpath & f
Excel 2010 :: Unable To Select ListBox Items
Feb 11, 2014I have a worksheet with a few "Multi-Select" type listboxes in it. I cannot seem to select the items within those listboxes... the mouse icon doesn't even change, it just shows that little plus-sign that is the default when you're just in your worksheet. (they're also ActiveX listboxes)
I can select them if I go into my Developer tab and select and deselect the "Design Mode" button. then everything works fine (mostly). Or if I resize the subwindow for the workbook. Then it (again, mostly) works fine.
It's like I have to trick Excel into allowing me to click on the checkboxes in my ListBox.
Some people I've given the file to use Excel 2007 and the file works for them. (I have Excel 2010)
I've looked up info on bound/unbound forms, but I can't tell if it applies, or how to use that. They were not created with a VBA macro, they were made using the buttons in the developer tab.
One final thing : Below the listboxes, I have some shapes that, when pressed, will take the selected items from their respective checkboxes and put them into some cells.
Here is the file: Setup form_Blank.xlsm
Unable To Calculate Copy / Paste Data In Excel
Apr 21, 2014I just copied a table from the web which contains numbers in the last column.
I pasted the data into Excel, but when I try to run any type of calculation i receive a #VALUE! error.
The annoying 'workaround' is to re-type the same numerical text into it's own cell, which allows for calculation.
I've tried changing the cell formatting to 'general', and 'text', but I still receive the #VALUE! error, when trying to calculate.
Excel Pie Chart - Unable To Use Sums For Fields / Axis?
Aug 4, 2014I have a set of data for hours of work. I want to make a simple Pie Chart: % of Hours worked overtime, and % of work not overtime.
The Data Looks something like this:
Name,Normal Hours Worked, Overtime Worked
David,8.0,3.2
Anne,8.0,1.3
Danny,7.0,0.0
Harry,8.0,3.0
Edward,8.0,2.3
So I want a pie chart that has 2 wedges.
~25% labeled as overtime worked
~75% labeled as normal hours worked
Whenever I put these values in the pivot table and use SUM, it is trying to sum based on # of hours matching, instead of by the column Name... so it gets divided into a bunch of different pie wedges.
Excel 2007 :: Unable To Enter Any Data In Spreadsheet?
Apr 19, 2008Very simple Excel 2007 spreadsheet. It consist of four columns with either numeric or alpha data in the. No formulas, no macros etc...
She emailed the spreadsheet to me and it works fine, I can enter data without problems. Whenever she tries to use it she just can't enter any data. She clicks in a cell and it highlights but she doesn't get a cursor and can't enter data. If she tries to click in the area underneath the toolbar to enter data she also does not get a cursor!! It used to work just fine for her but has suddenly stopped!
Excel 2013 :: Unable To Create Data Form?
Feb 7, 2014Excel 2013 on a surface tablet and attempting to create a data form. I've followed the necessary steps to try and add the "Form" button to the quick access toolbar, but "Form" is simply not a listed command. Have looked in "All Commands", "Commands not listed in the ribbon" and "Data Tab" and it's nowhere to be found. Not greyed out, just not there.
Frustrating because it's so easy to create a form on past versions of excel. All the tutorials I've seen online explain how to add "Form" to the quick access toolbar
Excel 2007 :: Unable To Set Pivot Table To Manual Update?
Aug 19, 2013I am using Excel 2007 and my version of visual basic is 6.5.
I am baffled by the behavior of this code to manipulate one of my pivot tables. I am trying to set all but one of the pivot items in one of the pivot fields to not visible. Because there is a large number of items, I wish to suspend all automatic updates until all items are properly set to visible or non visible.
------------------------------------------------------
Sub SwitchBoards()
Dim BoardNew As String
Sheets("Board Parameters").Select
' Make sure we get the right value.
[Code].....
The MsgBox returns with: "Manual update is set to False" right after the instruction to set it to True!!
Copy Charts From Excel To PPT - Unable To Resize And Format Chart
May 23, 2014I have an excel which creates PPT from the excel. but the graph pasted in PPT are not aligned and formatted.
By aligned, i mean re-size the graph and paste in a formatted fashion (currently they are overlapping each other)
My entire PPT created is off alignment and formatting. E.g heading are not properly aligned (they are touching the line below) and so on.
Excel 2010 :: Unable To Use VBA Check Box With Protected Sheet / Columns?
Jul 9, 2014I need to make a excel costing model to calculate various products prices. I am using Excel 2010.
I have many products and do not need all of them displaying at the same time, therefor I inserted a Checkbox (ActiveX Control) that hides my columns that I do not need. I did that by inserting the following and it works fine :
[Code].....
The problem is I now need to lock certain cells so that they can remain fixed and the recipe cannot change.
Once locked my checkbox no longer works and I get the following error :
"Run-time error '1004': Unable to set hidden property of the range class"...