Unhide columns through Excel Viewer
I have an Excel document that I am viewing with Excel Viewer. It is a
document of weekly totals, where the Author has hidden all of the
prior weeks totals. Author said to just "unhide" the columns, but
have been unable to locate where to do that through Viewer. Is it
A Viewer is a viewer. To change an Excel file you need Excel
"hummels" <email@example.com> wrote in message
>I have an Excel document that I am viewing with Excel Viewer. It is a
> document of weekly total...Exchange 5.5: X400 vs. Site Connector
Is there a performance difference between the Site Connector and X 400??
Let me give you a little more info, I have two sites which are connected via
a VPN (dedicated connection using T1's on both sides). I currently have an
X400 connector between the two sites, however...I'm moving my exchange
server to a new system in one side which means I'm going to have to rebuild
the connectors. I'm not using any scheduling, user priorities, message size
limitations or any of the advanced features of the X 400 connector. So the
only question left is...is there any performance/scaliabi...Emailing XML direct from Excel
Please help! I have a problem with Excel 2003 and Excel 2002 where if I open
an XML Spreadsheet file in Excel and then select File - Send To - Mail
Recipient as Attachment, Excel converts the XML to XLS before attaching it.
Is there someway I can make Excel leave the document alone so that XML gets
sent on? I need to open XML, allow changes to cells, save changes and send
as XML to be further parsed etc.
This works fine if the XML is opened in Internet Explorer (Excel 2003 only)
but not in Excel itself.
Could someone please test and tell me if this is happening for them too or
whet...Analysing data from several excel workbooks
I'm totally new to excel and i need to analyse the changes in a funding
position across several years in a seperate excel sheet.
As in, submissions are made year on year showing the amount of revenue spent
on several different services. I need to be able to compare how those have
moved over the last 5 years in a single spreadsheet.
I appreciate any help.
To give a clear answer we would need a bit more detail of the data layout
Give us a simplified version of what the data looks like
Your 'subject' talks about different workBOOKS but the text of the ...PDF file #5
I have Publisher 2002 and would like to insert a .pdf
file into a document I am working on. How do / Can I do
...Too Many Excel Apps running
I recently installed Excel 2010. My operating system is XP Pro.
Ever since I installed Excel 2010 I find that every time I open an
Excel file it opens a new Excel. It is not unusual for me to have 5
different Excels open even after I close a file. My bottom ribbon is
full of Excels! I previously used Excel 2003 and did not have this
I know these are different Excels operating because I am unable to
open a split window to show two different files.
Note - I usually open my files via Explorer.
Is there a setting that I can use to require that my single open Excel
can open any new Exce...Excel document changes format
I have an Excel document that changes format unexpectedly. It seems to
change the format of the document eventhough i saved it. I have to
resize the windows of the bar graphs, etc. It just doesn't save it the
way i want. I re-installed MSOffice and re-did the NT profile, but
still persists. Any ideas? Thanks.
Excel does seem to have problems if the screen zoom is anything othe
Usually changing to 100 and back resets he screen display
Message posted from http://www.ExcelForum.com
...Dotnnetnuke 5.0 adding a new page
If you need the basics on how to add a new page to dotnetnuke you can
follow this link, this is also a great website for more dotnetnuke
...Importing data #5
I have a workbook in Excel 2003 that I need some advice on please. The data
used in the spreadsheet is collected online into a CSV file, this CSV file
is imported into Excel onto a "Raw Data" worksheet. From this raw data
several other worksheets need to access this raw data to prepare the reports
required. I have the first report sheet designed and it picks up the data
from the Raw Data sheet. The problem I need help with is updating the raw
data; when I download a new file from our web site and refresh the data
import the report worksheet does not update correctly. Fo...Export Access Record to Specific Cells in Excel
I'm looking for suggestions on how to export data from an Access table or
Query into specific cells of a Worksheet. The table I'm importing will
always contain a single record only. For example, I'd like to export data
from Field1, field2...etc in an access table to Sheet2!A3, Sheet2!B3...etc.
Any sugestions would be most appreciative.
I'm planning on upgrading both my OS ( to OS X 10.4.1 )
and my Office ( to 2004 ) at the same time.
I'm planning to wipe my drive and update everything from
scratch. My question is regarding updating the Office
Will I need to install the earlier versions of Office and
Virtual PC to make this go? I own Office X and Connectix
Virtual PC 6 and have purchased the Office Professional
upgrade. I'd prefer to not have to install the earlier
versions if I can avoid it.
In article <firstname.lastname@example.org>,
email@example.com...GP 9.0 and Fabrikam
I want to provide access to this test company. I see the company in the list
when I start up GP Utilities, but it shows a lock beside it. How would I
access it. Also, there is no option to create or re-create Fabrikam.
Any direction appreciated.
It seems the sample company failed to be created the first time around,
which will force you to check a few things:
1) Verify whether the TWO database was created on SQL Server. Open SQL
Server Management Studio or Enterprise Manager and check in your databases to
see if it has been created. If the database is present, you w...Excel to publisher import
How can I import an excel spreadsheet to publisher doc.?
If you want to insert the actual spreadsheet, you can go to Insert > Object
> Create from file and browse to the Excel file.
If you want to merge the contents of the cells, you can use the Mail Merge
feature in Publisher.
Microsoft Publisher MVP
This posting is provided "AS IS" with no warranties, and
confers no rights.
"Bill" <Bill@discussions.microsoft.com> wrote in message
> How can I imp...Excel 2007 and Word 2007 Hangs when using the File -> Open command
I have a couple users that when they have Excel 2007 or Word 2007 open, and
click the File -> Open option, and choose a file, it either takes about 3
minutes to open the file or the program will crash. If they were to double
click on the documents or spreadsheets, the doc or sheet will open right up.
This is happening on the user's Hard drive as well as network drives.
Once you get a file opened in Word or Excel, however, the next time you go
to File -> Open, it's really fast to open the file.
...To get user training manual for Microsoft CRM 3.0
I am implementing Microsoft CRM 3.0 for an health care company in Michigan.
Right now I have experience with installation, customizing and CRM
application functions for 2 years.
In the future I would like to pursue my future as a Microsoft CRM
consultant. Thus, I would like to get all 3 of certificates of Microsoft CRM:-
3. Installation and Configuration
The problem I have is I work for a company which I am not permanent
employee, and this company is not Microsoft Partner also. So If I would like
to have user manuals for preparation to ...Exchange 5.5 config issue?
We're keeping our Exchange Server without much inhouse expertise, and
managing to support 140 users - so far so good. But I think we have a
setting or configuration problem. If an email in a client's Outlook Inbox
is there more than 2 or 3 days, reading, deleting, forwarding or any action
takes about 30 seconds to execute. You get the "Microsoft Exchange is
requesting Data from the server" dialog box with a subsequent 10 second or
so delay, and it's annoying. Is this a caching setting on the server, and
how can we extend the number of days that an email can be process...Linking Word and Excel #2
I have a Word document with a large number of tables
linked to cells in an Excel spreadsheet. The tables in the
worksheet are in the same order as those in the Word
document. I would like to insert a new table between other
tables linked to the Excel spreadsheet but when I insert
the new table between the others in the Excel spreadsheet,
it invalidates all the other linked information. I take
this to mean that the links are not absolute references.
Is there any way to do this without having to reconstruct
...Business Portal 3.0 Breaks SQL Reporting Services
I had a box with Windows 2003 Server, running SQL 2005 with SQL Reporting
Services up and running fine. SharePoint was also installed and running
Then I installed Business Portal and now SharePoint works, BP works but SQL
Reporting Services is broke. I have done an uninstal and reinstall of SQL
Reporting Services. Anyone see the error below or know what I should
Server Error in '/Reports' Application
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the speci...Mailbox Resources (exchange 5.5)
I have recently noticed a large volume of 'deleted items' building within the Exchange Administrator/Mailbox Resource
Checking the actual 'deleted items' folders for each user shows nearly empty versus the folder I can see in Exchange Administration, which shows several users 'deleted items' folders over 100MB. It is Cached? How can I clean this up?
"Steve" <firstname.lastname@example.org> wrote:
>I have recently noticed a large volume of 'deleted items' building within the Exchange Administrator/Mailbox Resources
>Checking the actual '...Excell 2007 messing up graphics
I have an invoice Excel sheet setup with my company logo on it. For
some reason Excel 2007 messes it up during printing. It prints it
about 10 times the size. I tried to re create the work sheet and it
still will not print the graphic. It show it ok but will not print
it. When I go to Print Preview the logo (JPG graphing) is not seen at
Any Ideas what is going on?
...can you date time stamp entries in excel
is it possible that when someone puts an entry on a shared worksheet in excel
it can automatically date and time stamp their entry.
Private Sub Worksheet_Change(By Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then
.Offset(0, 1).Value = Format(Now, "dd mmm yyy hh:mm")
Application.EnableEvents = True
'This is worksheet event code, which means that it needs to be
'placed in the appropriate ...Hierarchical Worksheet Tabs??? New Excel feature?
I do not know if newer versions of Excel than I have have this function, but
in working with a budget in Excel, it sure would be a nice feature to be able
to "stack" in a hierarchy the worksheet tabs at the bottom, instead of
scrolling horizontally for hundreds of feet! In other words, I want to have
a Worksheet "Travel Budget" and instead of having each month's in a
horizontal tab, I could scroll up and down from a "Master" worksheet to
sub-worksheets ties to the master...instead of just adding worksheet after
worksheet in an ever growing hard to mana...excel #18
I have works 6.0 instaled on a xp system but i want to
upgrade to excel because i have save document as save
type formated text(space delimited)(*prn)and works does
not have this format.
First, I don't use MSWorks.
But if that's the only reason for your upgrade, you might want to try this to
see if it works in MSWorks:
In excel, you can concatenate a bunch of cells into one cell. You could use the
=concatenate() function or the & operator:
will join a1, b1, c1 in one cell.
But if you're shooting for .prn file (fixed width), you could see if you have
t...Quit Excel problem
Can anyone tell me what's wrong with this macro? Its meant
to save the spreadsheet (which it does), shut down the
worksheet (which it does) and quit excel (which it
I wondered whether it had something to do with the
worksheet containing the macro shuting before excel
executed the quit, but if I take out the
ActiveWorksheet.Close, whilst excel closes I get a
Dr.Watson application error.
' Exit_Save Macro
' This macro saves the current work and quits the
Application.DisplayAlerts = False
FileN...Catalog & Excel formatting
I am using Excel as a data source for a catalog. One of the price fields in Excel is a 'currency' format and is the result of a formula. Publisher imports the field but only displays the figure as 45 instead of £45.00. Anyone know of a solution to this problem ? I can get around it by re-formatting the field as a 'number' format but as most catalogs will involve lists of products with prices I think the 'currency' format should work.
The best thing to do is do a SAVE AS in CSV (Comma Separated Values) and add
a � to the figures and then copy and paste th...