Sharing a calendar
I need to set up a meeting room calendar for the staff to use.
However, in doing so the calendar seems to be linking with my own one. EG: I
created various Catagories within this new calendar and it changed mine on my
default calendar. Secondly: Each time someone books the meeting rooms, I am
included automatically into the reminder.
How do I create a calendar that can basically stand alone, where I can set
up the categories etc and it will show up seperate to everyones current
I am sure this can be done - however not sure how....Please help!
Much appreciat...how to type in excel
typing letters or numbers do not show in excel
First click on a cell.
Then type some letters or numbers
Lastly touch in enter key
> typing letters or numbers do not show in excel
...Excel 4 macro support--how long?
Hello, I'm looking for information on how much longer MS is going
support Excel 4 macros in subsequent versions of Excel. Does anyone
have any info on this to share?
Thanks in advance,
Message posted from http://www.ExcelForum.com/
Anything you get will be pure speculation. I suspect it will be around for
one more release at most as it hasn't now been the 'preferred' macro code
for some 12 years.
They will need to fix some of the issues with VBA before this though, for
example, the slowness of pagesetup in VBA against the Excel 4 macro code
Nick ...New to excel-feel really stupid
When I type in a date in a cell, it gives me a five digit number that
doesn't relate to the date. What have I done? Also, I want the $ sign
to appear in the cells but it won't.
This will be Excel's interpretation of the date (which will be the number of
days since 01/01/1900). I'm guessing that the cell was already formatted as
a number and therefore would not show your entry as a date. Just go to
Format / Cells / Number and select a date format to suit.
<email@example.com> wrote in message
>...How can I increas undo level in Microsoft EXCEL ?
By default there are only sixteen undo level in Microsoft Excel.But
i want to increas undo level more than sixteen. Please guide me how can i
solve this problem? I will be very graetful to you. Thank you.
AFAIK, you can't.
In article <EDBDC76B-F65E-468A-83BE-FB6097E9A508@microsoft.com>,
"Sajid Siddique" <Sajid Siddique@discussions.microsoft.com> wrote:
> By default there are only sixteen undo level in Microsoft Excel.But
> i want to increas undo level more than sixteen. Please guide me how can i
> solve this problem...Excel macros #5
I have recorded a Macro to import a Text file and then sort it
When I try to use the macro using the Keyboard shortcut the macro stops
after importing the file - ie it does not do the sort
However if I step through the Macro using F8 it works OK
John Eakins's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=8325
View this thread: http://www.excelforum.com/showthread.php?threadid=497335
Not without seeing it.
(remove nothere fro...Excel Pivot tables and charts
How do I retain pivot chart formats that I have made (esp. column colours)
after refreshing the data on the source pivot table?
Loss of chart formatting wwith regards to pivot charts is a know
problem, which requires VBA to re apply recorded formatting.
XL2000: Changing a PivotChart Removes Series Formatting (Q215904)
> How do I retain pivot chart formats that I have made (esp. column colours)
> after refreshing the data on the source pivot table?
Andy Pope, Microsoft MVP...Using CRM Bulk Import Wizard with Excel 2007
Hello, a number of our hosted Microsoft CRM customers have reported
difficulties when using the CRM Bulk Import Wizard with a CSV file generated
from Microsoft Excel 2007.
It seems that Excel 2007 no longer uses double quotes (") as a field data
delimiter, and there are no options or other Excel 2007 formats that will
achieve this. (No idea why Microsoft disabled this option in Excel 2007!)
Users are having to import their Excel spreadsheet into Access 2007 then
export as a TXT file, which Access formats with double quotes as a the field
data delimeter by default. Or resort to an ...Hidden Rows Appearing!! Shared Workbook
I have a large workbook where I have many people entering data. When they
enter data, it gets accounted for on a seperate metrics sheet/tab. Cells B2
thru L33 are all forumlas so it's nice sized. I am using 3 of the rows for
accurancy counting and reference for some formulas and they are hidden from
view because the end user doesn't need to see them. (duh!!) Many times I'll
come in and these rows are viewable like normal. They keep switching back!
Has anyone heard of similar problems? Or is someone in this office manually
changing them back on me, without telling me? Could t...merge is disabled
I'm working in version 2002. For whatever reason, in this particular file,
merge is greyed out. Does anyone know how to enable it.
I have some text that I want to merge over a few cells so that I can print
this puppy on one page.
Look to see if sharing is turned on, having said that there is no really
need to merge cells for printing, in fact unless you use merge in the top
rows to merge more than one row and you'll never copy and paste into those
cell of from those cells it's a waste of space and in fact the evil of evil.
Once you have to audit a large spreadsheet...Can I "Save As..." an Excel Sheet to an Access Table?
I want to "push" data from an Excel report to an Access database.
Do you know if there is a VBA script that saves an Excel sheet as an Access
Do you know if there is any other way to "push" data from an Excel report to
an Access database.
The Excel report is different every day, the Access is the same and keeps
You can open an Excel sheet in Access. With that in mind, I would suggest
writing an append query in Access to add the details from the Excel sheet to
the existing table.
"John Bixtis" <john_bixtis@ho...how to share a theme with other PPT users?
I've developed a nice set of corporate colors (PPT 2007) under the Design
tab/Colors/Create New Theme Colors. How can I share this set of colors with
my coworkers? I thought it traveled with the PPT doc, but turns out it
didn't. Or maybe I need to save the PPT a different way? Thanks for your help.
YOu could delete all the content, then do a Save As and save as the file type
..pot (powerPoint Templates) You could then send this file for others to use.
They can either create new presentatons using this template or they could go
to Themes, and click the drop down to ...Labels and excel
I have an excel sheet that I keep as a log, it looks something like
COMPANY NAME, SERIAL#, TEST PRESSURE, TEST DATE, PART NUMBER
under the heading goes the data, but now I need to print each line off as a
label to attach to the equipment we sell (very small pipes and equipment for
oil rigs) is it possible to print each line of data and the headings (above)
as a single
label? I want to pick a line of data and use the headings to print one label
or many for different bits of equipment or am I asking to much? I use Excel
2007 also 2003 help in either
would be great.
Please be as kind a...Opening Excel Spreadsheet and no data it is blank
Coworker asking me to reveiw their work and when I try and open excel
it shows "ready" but there are no columns or rows it is all gray. But
if I choose to look at full screen I can see everything except all the
additional tabs. When opening this spreadsheet on another computer it
is fine. When opening another file on my computer it is fine. Just
this one file shows blank even though it is not.
and resize the way you like.
It's a common problem with different window settings on different pcs--I bet one
of you is using a desktop and the other a lapto...The macros in this project are disabled.
From the ControlBox when clicking on the Exit Design Mode button, I
get a message:
The macros in this project are disabled.
This is preventing me from running my project.
Any Ideas ???
Try Help>About Ms Excel>Disabled items.
Anything there that you can re-enable?
Gord Dibben MS Excel MVP
On Sat, 10 May 2008 14:16:53 -0700 (PDT), Greg <ApexData@gmail.com> wrote:
>From the ControlBox when clicking on the Exit Design Mode button, I
>get a message:
>The macros in this project are disabled.
>This is preventing me from running my project.
>Any Idea...Exchange backup disabled user
We are running Exchange 2000 and Veritas Backup Exec 9.0
When a user leaves, we want to:
Disable the AD a/c and stop the user from receiving mail, backup the
mailbox, then delete it after 30 days (default retention period).
We want to disable a user the day that they leave so they no longer
have access to our network. The problem is though that we cannot
backup the mailbox while the AD a/c is disabled. We would like to
leave the mailbox in the backup schedule for 30 days so that it is
backed up onto the tape which we store away once a month (therefore we
always have a backup of...Sharing Sent Items folder
I use Outlook 2003 in an Exchange 2003 environment. The
Sent Items folder of an account can be shared by right-
clicking, select Sharing, and setting the permissions.
But how can another user now access this shared folder?
If they click File | Open | Another User's Folder, the
Sent Items folder is not listed.
Presumably it must be possible for User B to do this,
otherwise it wouldn't make sense for User A to be able to
share the Sent Items folder in the first place.
Thanks for any help you can give!
There are only a few folders that you can access using the File > Open...How do I create a calendar from data in excel?
I have two columns with dates in them and would like to display a calendar at
the bottom of the page. Is this possible?
Try a 3rd party application like WinCalendar...
With this you can insert a Calendar into any excel sheet. You can
also save daily appointments on a floating Calendar that later display
on the inserted calendar.
Refer to http://www.wincalendar.com/ for more info.
On Jul 31, 12:00 pm, kare7272 <kare7...@discussions.microsoft.com>
> I have two columns with dates in them and would like to display acalendarat
> the bottom of the page. Is this possible...Bank Management Outstanding Documents
I am running GP 10 with SP2, i have noticed in bank management module some
transactions are appearing as outstanding yet i had reconciled them and even
closed period for the chequebook. Any help?
I hope you can help with a problem with a spreadsheet
caused by compatibility between word & excel
I had a multi-page spreadsheet which I opened via Word by
mistake - some of the data is now missing in word
Now I can't open the spreadsheet other than in Word
although it is still a.xls file
Opening in Excel you get "file format is not valid" error
message. It will open in Word but not all the data is
there. Can I recover this file?
I don't think you can - maybe someone else can prove me wrong, but I think you
need to be looking for a backup copy if you can find o...Minimise Excel after several minutes
Is it possible to have MS Excel 2003 minimise its self after several minutes
when it's not in use?
Not that I could think of, certainly through the GUI. It can be minimised
through VBA but the difficulty would be detecting activity
Microsoft MVP - Excel
"Wayne_Perth_WA" <WaynePerthWA@discussions.microsoft.com> wrote in message
> Is it possible to have MS Excel 2003 minimise its self after several
&g...Sharing calendars #3
We just upgraded to Office 2003 (almost completely now).
Various workgroups at my work have calendars in the Public Folders that contain
stuff like vacations. But we haven't been able to figure out how to use these
effectively. I sometimes print my schedule by copying my calendar, and then
cutting and pasting this calendar into my copy, printing a couple of months,
then deleting this copy.
In group meetings various people keep saying that we should find out how to use
Outlook's calendar functions better. This gets a lot of talk, but little
action because nobody knows more than...Excel 2002 Changes Screen Resolution
When Excel 2002 launches, it changes the screen resolution
to 640x480. How do I get it to stop this?
That's new one! Just to be sure that it is Excel, and not something that is
loading with Excel, from Start->Run enter "Excel /s" (no quotes) and press
Enter. This is "safe mode" where nothing extra runs. If it doesn't happen
then you know it's an add-in or something auto-loading from ,say, XLSTART.
"Sheila B" <firstname.lastname@example.org> wrote in message
...moving from excel 11 to excel 12
Excel 2007, wXP
New XP computer with Excel 2007 (Excel 12) and leave my old computer with
Excel 2003. I had a bunch of macros in the old computer, but I believe they
were not all attached to specific spreadsheets and I could see a list of all
macros and invoke the one I wanted. With the Excel 2007 computer it seems
that the macros were imported attached to the workbooks to which they
pertained, but I had a few macros in the old system that could be used
anywhere, such as one that caused a "comment" to be written without my
initials embedded in it, and it could be used in any ...Default Template (Excel 2000 for Windows)
Does anyone know where Excel stores the default template settings for
worksheets? When I start up Excel, the Fill Color icon in the formatting
toolbar defaults to yellow. I would like it to default to another color.
I am aware that I can set up a custom template but I am just curious to
know where the default settings are stored.
The default settings are stored internally. If you put a template named
"Book.xlt" in your XLStart folder, that template will be used for new
In article <email@example.com>,