How do I make excel hide columns when it says cannot move objects
I select columns and try to hide them. Excel says it cannot shift objects
off the sheet. I try goto objects and it says there are no objects on the
sheet. I cannot hide or resize the column widths of certain columns. I
cannot figure out why I can't get it to work and hide or resize the columns.
Does anyone have any idea how to fix the columns so I can hide/resize the
columns? It only does it on some of the columns, not all of them. I can't
find any objects to delete.
...Text & Date same cell
Sheet1 has date in A1 (1/1/2005) formated as Date.
'=IF(Sheet1!A1>1,"MyDate" & Sheet1!A1) <- formated as Date
'="MyDate"&IF(Sheet1!A1>1,Sheet1!A1) <-formated as Date
Both display -> MyDate38353
How can i make it display -> MyDate1/1/2005
Desert Piranha's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2893
View this thread: http://www.excelforum.com/showthread.php?threadid=49296
=&q...Re-arranging table using pivot-table?
I have a worksheet with data organized somewhat like this:
New York New York
New York Albany
California Los Angeles
California San Diego
I need to convert this to a list of states and each city in the columns to
the right of their corresponding state. Something like this:
New York New York Albany
Florida Miami Orlando Tampa
California Los Angeles San Diego
Any help is greatly appreci...Saving files when closing Excel
Excel does not prompt for saving changes when closing a file after changes to
the file have been done.
have you checked that there's no event macro in your file?
Jonathan Gold wrote:
> Excel does not prompt for saving changes when closing a file after
> changes to the file have been done.
...can you convert an excel document to a powerpoint doc,
i have an organizational chart in excel and need to convert it to powerpoint.
Is this possible.
"dolphin" <firstname.lastname@example.org> wrote in message
> i have an organizational chart in excel and need to convert it to
> Is this possible.
...Generating Charts in Excel
I am trying to general a line chart that counts the number of items in a
range (A23:A160), but will depend on the dates in range (C:23:C160).
Basically, I want the display on which date the data in range (A23:A160) was
at it's highest peak?
...Re-install Outlook 2002
I am trying to re-install Outlook 2002 for my palm pilot
after a crash. The installation will run until I get the
message - "another version is already installed and must
be uninstalled". The previous version was corrupt and I
was unable to uninstall it. Now when I go into the control
panel to add/remove the uninstall is no longer in the
...RE:Excel will not open from a web link
When opening a link on a web page that has an Excel
Spreadsheet embedded in it, the spreadsheet will not open
up Excel but opens within another browser as an Excel
file. Programming on webpage is correct, opens up on
other machines just fine.
...Excel 2007 Line Chart
Is it possible to configure a line chart in Excel 2007 to ignore the
intervals and graph straight to the next value. For example if I have
Jan with the value 1000
Feb with the value 900
March with the value 500
April with the value 0
May with the value 0
June with the value 0
I want the March value to drop directly from 500 to 0 ignoring the
interval to April, I do not want a curved line it must drop directly
to zero then the line is straight across to April.
I have no idea if this is possible, any ideas?
On Tue, 11 Oct 2011 15:40:45 -0700 (PDT), TyreDu...Excel Headers
Can I set up more than one header / footer in excel.
I don't want the header to appear on all pages, just a few select ones. And
on some pages, I want different headers, or footers.
Posted via a free Usenet account from http://www.teranews.com
You could change the headers, print the page, change the headers, print the
Ron de Bruin has some sample code that may get you started (if you want to try
using a macro):
> Can I set up more than one header / footer in excel.
> I don't want the ...Excel Icon for files
I am running Windows 2000 professional on my PC and connected to a LAN. I
am running the MS office 2000 Professional suite. When, I save a worksheet
from Exel 2000 it does not save the file with the common Excel file
Icon(green X). The file is displayed with the default Windows Flag Icon.
When I double click on this default Windows Flag Icon the system tries to
open the file with Word not Excel.
Word and PowerPoint both save with their common Icons. The Excel program
saved fine a couple of weeks ago. I have not installed any new software and
our server takes care of Virus protection thro...Re-Enable CRM User
I am trying to enable a disabled CRM user and I received the following error
message. Any thoughts or suggestions would be greatly appreciated.
String UserId) +0
Microsoft.Crm.Application.Platform.SystemUser.Activate(String id) +38
sender, DataEventArgs e) +127
eventId, FormState state, User user, String objectId,...formatting excel
I am trying to make score sheets for a dart league I play in, and I would
like to find out if I can rotate the entire setup of excel so that the rows
are parallel with the long side of the page. Is this possible?
I think you want Copy, Paste special, Transpose.
"pikeylover" <email@example.com> wrote in message
>I am trying to make score sheets for a dart league I play in, and I would
> like to find out if I can rotate the entire setup of excel so that the
> are parallel...Word table to excel
Is it possible to copy a word table into excel. I have a folder with circa
200 files that I need to import into Excel. I have got the code to access
word but am struggling to copy the tables.
I found some macro in my archieves, but not sure if I ever got them
fully running. You are welcomed to try them
Set ExSht = ActiveSheet
FName = "c:\temp\abc.doc"
WordWasRunning = True
On Error Resume Next
Set WDApp = GetObject(, "Word.Application")
If Err.Number <> 0 Then
Set WDApp = CreateObject("Word.Application&...excel.exe has generated errors #2
Sorry for the cross post.
I am receiving the following message:
""Excel.exe has generated errors and will be closed by Windows.You will need
to restart the program
An error log is being created.""
when trying to open xls files that have been copied from another computer.
Both Excel versions are the same and the file works on the source machine. I
am copying it to and from a floppy which also works when opened on the
Any ideas will be greatly appreciated.
Thanks in advance.
Have you copied the file from the floppy to your hard...Printing labels from excel #3
Can I print labels from excel? If I can is it possible to merge address I
have on a word doc to excel? I have 16 pages of labels that I want to put
into excel so that I can use the filter and send out to just a certain city
and so on.
I also want to have the addresses in excel so I can sort.
Can anyone help me?
They need to be in a specific layout.
What is their layout now, Linda? See if this helps:
VBA Project Manager
"Linda" <Linda@discussions.microsoft.com> wrote in m...Re: exmerge error
I am getting the following error when trying to use exmerg
can anyone please help
Microsoft Exchange Mailbox Merge Program, v4.00.02
Start Logging:February 27, 2004 20:04:3
[20:04:31] Logging Level: Non
[20:04:31] Reading settings from file 'C:\Program Files\Exchsrvr\BIN\EXMERGE.INI'
[20:04:32] Error 8007203a opening an LDAP connection. ('LDAP://EXCHANGE/rootDSE') (CADRoutines::GetNamingContextData
[20:04:32] Accessing Domain Controller 'PROFI...Thanks Ken Wright but one more question RE saving data from circular references
Thanks heaps for that macro Ken Wright .
I have run it and it works.
However it loops forever. Can I set it up so that it could save dat
from a certain number of iterations?
Thanks again Michae
Message posted from http://www.ExcelForum.com
If you stayed within your thread and did not change the subject
Ken would see your reply as a reply to his reply and would see
it a lot faster than when you start a new thread. Ken would
probably see your post highlighted in RED. Also someone other
than Ken might have been able to help you. (not me I avoid
anything that hints of circul...Vlookups to Excel Version 3 files.
I use a system that on a daily basis creates an Excel
version 3 file containing cost centers and their budgets.
When I do vlookups from other Excel 97 files to this file
it takes a long time for the sheet to calculate. If I save
the Excel V3 file as Excel 97 its OK, and if the Excel V3
file is open before the 97 file its OK. I don't want to
have to constantly save the V3 file as 97 (I may not be
around to do that always)
Does anyone know how to resolve this.
...Ron Bovey re: "Trim Selection" in ExcelUtilities
Cells in my Excel spreadsheet appear to be empty. However, when I use
Edit/Go To/Special/Blanks, I get "No cells were found".
In the past, Ron Bovey suggested going to the WWW.APPROS.COM website,
download ExcelUtilities and then use the "Trim Selection" utility to
remove the characters that are making the cells not empty.
Since then, I've gone to the WWW.APPROS.COM website and downloaded the
ASAP Utilities. However, I can seem to find the "Trim Selection" nor
any utility that will do the same thing.
Try going to Rob (not Ron) Bovey's site:
...Calendar in Excel #2
Can someone help me with a calendar to use in Excel that
can be formatted so as to show special dates, current
holidays, etc. WARNING: I need explicit instructions. This
sort of stuff is not intuitive to me.
Why not do your calendar in Outlook. Select which style you
want....day/week/month. Then go to new input important dates. Save. Print
"Dot Appleman" wrote:
> Can someone help me with a calendar to use in Excel that
> can be formatted so as to show special dates, current
> holidays, etc. WARNING: I need explicit instructions. This
> sor...How do I get invisible lines & borders to re-appear?
In Publisher 2003, table grid lines, text box borders and autoshape borders
have become invisible on-screen, although they do print out. Any ideas on how
to remedy this?
Recently installed Adobe PDF Maker which seems to have precipitated this,
although it could be entirely co-incidental.
Try updating your video drivers.
MVP Microsoft [Publisher]
"Ackerman & Co" <Ackerman & Co@discussions.microsoft.com> wrote in message
> In Publisher 2003, table grid lines, text box borders and auto...Excel Answer Wizard BROKEN
call this a flame if you want... for Years, I have tried
to use the Excel Answer Wizzer, with extremely limited
success. I have never found any source for suggestions
about HOW to use it (including Excel Help) - for instance,
I wantto UNLINK a workbook - can't find the answer
anywhere. In the past I have found this usually means it
can't be done, but GOD FORBID misero-soft tell me that.
Have a great day.
PS: return flames welcome at : firstname.lastname@example.org
In the newer version you can use Edit>Links
But I think you love this Add-in
Try this Add-in to find the links
...re re re ????