Office 2010 and Basic Authentication on IIS fails to open documents
I have just upgraded my Office 2007 to 2010 (yes the RTM build) and am
running into some serious trouble accessing documents stored on a web server
or SharePoint server configured to only allow Basic Authentication.
Word opens as expected but does not do anything else (no prompt, no document
download, nothing). Accessing any Office document on a server or SharePoint
2007/2010 server that has e.g. Integrated Windows authentication enabled,
all is good I get prompted for credentials and the document downloads and
opens as expected and as in Office 2007.
Where is the settin...VBA Form Combo Box question.
I know this is most likely a simple question, but I'm stuck :(
I not to populate a Combo box in an Excel spread sheet I just enter
the location in the ListFillRange (EmpData!A1:A100).
But I got creative and tryed making a Userform with VBA.
Now I'm lost :(
In VBA the combo box doesn't have a ListFillRange....
One place I read to enter the location in the ControlSource field, but
it doesn't take the information. It keeps giving me an error message.
Can anyone Help Please?
See response in worksheetfunctions.
(remove nothere from t...How do I create a database from an Excel form?
Hello Everybody -
I need to see if Excel can be used to create a mailing list database from an
Excel form. If so...how do I go about doing this? The list will need to
include the name of the company, contact person, and address.
Thanks in advance for all of your help! It is greatly appreciated!
Here are a couple of links:
The first is from David McRitchie and the second is by Beth Melton and Dave
> Hello Everybody -
> I need to see if Excel can be used...OWA 2003 Log Off Button gives HTTP 500 Internal Server Error
When Logging off of 2003 OWA I get a page cannot be displayed error message.
Everything else seems to be working fine.
There's a KB about this.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Warren" <Warren@discussions.microsoft.com> wrote in message
> When Logging off of 2003 OWA I get a page cannot be displayed error
> Everything else seems to be working fine.
I did a search in the Knowledge Base and found nothing!!!! Help!
...Tax button on bank transaction screen
Are there plans to incorporate the Tax Entry button (which can be found on
Transactions - Financial - General screen) on the Bank Transaction Entry
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/...How can you set up a form that the cursor only moves to cells tha.
I have set up a form. Now I want my cusor to move through the worksheet
only in certain cells. I want to be able to go from one cell that needs to
be filled out to the next cell that needs to be filled out automatically.
Example , move from cell a3 to c19 automatically. How can I do that?
You can accomplish that by setting sheet protection.
Select all the cells that you want to be able to navigate
to then goto Format>Cells>Protection tab. Uncheck Locked.
Now, goto Tools>Protection>Protect sheet. A list of
options will appear. Uncheck Select locked cells and check...Adding Contact information to a form
Hello - I am trying to get multiple contact entitys to display on a custom
I have created a custom entity called 'Special Account information' It has a
number of custom attributes that we do not wish to add directly to the
account record. It is the child of the Account entity. I have made the
Contact entity a referential child of 'Special Account Information' so it can
have its own contacts, whether entered new or selected from the existing
contacts in the system.
I am working with the main application form. I am displaying all the custom
attributes f...Unable to open .xls file
I have Windows XP Home edition on my computer and I received an email with
some info that is an .xls extensoin. I have Windows Worksheet and wanted to
know how, if I could, look at this file? I also receive info with >pps
(powerpoint) and am unable to open these files also. ANy suggestions?
You may not have MSOffice. It's not part of Windows. It's a separate suite of
But MS does make a viewer for excel:
and one for powerpoint:
http://www.microsoft.com/downloads/details.aspx?Fa...Open Spreadsheet--Formatting Changed to Date??
I opened my spreadsheet and some, but not all of the columns on every
sheet in the workbook has changed to a date format. I opened other
spreadsheets and there was no change.
Can anyone explain this. It's a real pain to deal with.
...File Menu button is now an icon
I succeeded in changing File Menu to the Excel Icon and have no idea how I
did it or how to get it back. The result is that a left click on that icon
will bring up the Restore Menu and a right click will bring up a seriously
abbreviated File menu. Two commands I use quite a bit are Set Print Area and
Clear Print Area and neither are present on this abbreviated menu.
It sounds like you're still using xl2003 or below (not xl2007 with the new
If that's true...
I'd try this first.
Rightclick on an empty spot on any of the toolbars.
Cho...empty pivot table fields
How can I force a pivot table to, for example, say that there were no
accidents in week 2. At present it says 3 in week 1 then jumps to 2 in week
3. I want week 2 =0 for charting purposes. -thanks
Right-click on the Weeks field button.
Select Field Settings
Add a check mark to 'Show items with no data'
> How can I force a pivot table to, for example, say that there were no
> accidents in week 2. At present it says 3 in week 1 then jumps to 2 in week
> 3. I want week 2 =0 for charting purposes. -thanks
Excel FAQ, Tips & Book...MFC CPropertySheet: hiding Apply button partially works
I am hiding the Apply button in a property sheet by using the following code
before creating it:
m_psh.dwFlags |= PSH_NOAPPLYNOW; // remove the "Apply Now" button
This works in the sense that the button is gone, but what I'm finding is
that the "A" hotkey is still assigned to it!
If I add a checkbox to one of the tabs, for instance, and I underline the
"A" in the label. If I hit Alt-A it will only set focus to the checkbox but
not check it.
This is the behavior that you get if you have another field with the same
hot key, but there is none. My only tho...CButton SetBitmap makes button lose xp style
This is probably a really silly question, but I can't seem to find an 'easy'
solution to this problem. I'm attempting to make bitmap buttons on the
dialog, but these different dialog templates would be using the same class,
and since i want to retain XP button style, i didn't want to use
CBitmapButton with the owner-draw buttons.
Using SetBitmap gets the bitmap shown on the button, but then the button
goes back to classic Windows style, whereas other text buttons retain the XP
look. Could someone please help?
Thanks in advance,
"Isa" <...Pivot Table Drill down
Is there a way for the drill down data to retain its Hyperlink. When I
drill down on the Pivot Table I would like the original Hyperlink
status from the source data to be retained.
Message posted from http://www.ExcelForum.com/
Don't understand your problem here. Excel automatically retains the lin
to external data so you can use menu 'Refresh' to update the table a
any time - assuming the source is in the same place as before..
If you want to move a source file elsewhere, open the one with th
pivot table first and use File/Copy, when the link will automaticall
change (if ...Convert Word Table -> Excel without merged cells?
Whenver I copy/paste tables from word to excel, I get merged cells in
Excel whenever there are line breaks in the word table cells. How can
I avoid this?
Saved from a previous post:
If your cells in your word table contain paragraph mark or linebreak characters,
then excel will bring them over as separate cells.
One way around it is to convert those paragraph marks & linebreaks to unique
characters, then copy|paste and then convert them back to linefeeds.
I like this technique (inside a copy of the word file):
Select your table.
Edit|replace|Special (show More if required)...Unable to make a pivot table in sheet2
Can someone pls check below code.
I'm able to export a query from access to excel in file "Myfile.xls"
sheet1 but unable to make a sheet2 with pivot table of sheet1 data.
Option Compare Database
Public Sub TransferReport()
Dim varFileName As String
Dim xlApp As Object
Dim xlWb As Object
Dim xlWs As Object
Dim MyRange As String
varFileName = "D:\MyFile.xls"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "MONTH
END REPORT", varFileName, False, "Sheet1"
Set xlWb = ActiveWorkbook
xlWb.Sheets.Ad...Command Button To Screen Grab
Good afternoon all.
I was hoping somebody might be able to provide with some possible
ideas on how to achieve the following......
I have an Access form to which I want to add a control button, which
upon being clicked will do a typical ALT + PRNT SCRN type screen grab
and then save this as a file, or at least paste this to an image
object and then save the image object as the file.
The problem is that there appears to be no way of doing a PRTN SCRN
with the sendkeys function, so I'm now a bit stumped.
Any insights would be most appreciated.
...Multiple buttons to control data source on a report.
I have a single report I would like to use. The table is structured
with several columns. Is there a way to have multiple buttons on a
form, and configure each button to open the report using a different
data source (different column).
So button 1 would be a report using column 1, and button 2 is for a
report for column 2, and so on.
On Wed, 29 Aug 2007 14:06:46 -0700, ghmag <email@example.com> wrote:
>I have a single report I would like to use. The table is structured
>with several columns. Is there a way to have multiple buttons on a
>form, and co...AfterUpdate Form Event Fires Repeatedly
I've been having this problem for a few months with a db I'm working on. I
know there must be something simple I'm overlooking, so I'd greatly
appreciate any help in identifying what the problem is.
I'm using the following to create a timestamp:
Me.dbLastUpdateUser = Forms!frmUserInfoHIDDEN!txtUserName
Me.dbLastUpdate = Now()
frmuserInfoHIDDEN refers to a form that is hidden on startup that stores the
name the user logged in with. This feature works fine.
The AfterUpdate timestamp used to work as well. However, now it repeatedly
fires and forces the user to stay on ...Keeping Context Menu open after Command
I've added a context menu to my CListCtrl that allows columns to be
hidden. Is there a way to keep this menu open after the user clicks on a
Basically like in the customize toolbar menu in Visual Studio.
Olaf van der Spek wrote:
> I've added a context menu to my CListCtrl that allows columns to be
> hidden. Is there a way to keep this menu open after the user clicks on a
> Basically like in the customize toolbar menu in Visual Studio.
Bump. Somebody, anybody?
I imagine you would have to start think "modeless dialog&...Pivot Table dropdowns
My pivot table dropdowns keep data whether it is still valid or not.
I am expecting it to behave like a filter dropdown which refreshes each time
you use it.
Is there some way of refreshing the data ???
My list is now 3 times bigger than it need to be the only way I can get rid
of the old entries is to delete the pivot and re-create it - which is time
Any suggestions would be warmly welcomed...
There's information here on clearing old items in a pivot table:
Suzy From OZ wrote:
> My pivot table dropdowns keep d...Fixed asset tables missing
I have a client that is running MS Great Plains v8 with multiple
companies. There is one company that has seemed to lost their fixed
asset tables. There are no tables in that DB that start with FA.
This company really does not use fixed assets but there is a problem
with posting invoices they are receiving the following message:
Unhandled database exception
A get/change operation on table 'FA_Company_SETP cannot find the
Invalid object name 'DPF.dbo.FA49900'
I really am not sure what to do to fix this. Any help on this wo...opening Word Perfect 11 documents in Word
Operating System: Mac OS X 10.6 (Snow Leopard)
I have recently switched from a PC to Mac. I have numerous Word Perfect version 11 (for Windows) documents that I used to be able to open in Word on my PC. I can no longer open them. This is a serious problem because it would take hours to convert all the hundreds of word perfect files to Word on my old PC and then transfer them to my MAC. Any suggestions? <br><br>Thank you. <br>
I'm afraid WP filters have not been supplied with Mac Office since a few
versions after Corel (I ...Can't open e-mail. It Freezes ...I have Office Enterprises 2007
A few days back I downloaded Office Enterprises 2007. Every thing went O.K..
Had e-mail for a couple of days. Now when I go into my e-mail (I can't) as
it freezes up. Can't open e-mail messages , or send. My Internet Explorer
works fine ,
so I do have excess to the internet. What is wrong ???? I do have dial-up ,
but this should not make my e-mail freeze up.
May I add....I was able to open a message or two , but it took so long , and
think I was luckey at the time for whatever reasons. !!!HELP!!!
Did you already get the Outlook Performance Update? If not, I'd start
with that...Many similar issues: A save operation on table...
Client is using v7.5 and recently began having some errors pop up. Users
-- A save operation on table SOP_Line_Work failed accessing SQL Data
-- A save operation on table POP_PO failed accessing SQL Data
I made a backup of Dynamics and the company DB
-- ran checklinks on all (there was a similar error message during SOP Work)
-- ran SOP Doc Utils
-- Deleted stranded sessions in SY00800, SY00801, and Dex_lock and
-- Deleted duplicate SOP records in Work and History
-- Deleted SOP records not in batches
-- Drop and created Auto Procs
-- DBCC CheckDB and CheckCata...