Home » Business » Page 1
Microsoft Excel Issue
Category : Business
Microsoft Excel Issue
  Whenever I open a saved excel file in my system,the whole format gets changed.The fonts,colours,formulaes etc.Even the date format gets changed.How do I resolve this???

View Replies


Excel 2010 trigger macro when a ribbon tab is selected
Category : Business
Excel 2010 trigger macro when a ribbon tab is selected
  Hi,
I was wondering if it is possible to trigger a macro when an particular custom tab is clicked.
This is part of my XLM code from the Excel file:

Code: <!-- Add Custom group to the Home tab in the ribbon with one button-->
<customUI xmlns=&

View Replies


Converting Outlook imap to pop3 - Minimizing losses
Category : Business
Converting Outlook imap to pop3 - Minimizing losses
  Now the email is setup as imap. This relates to a single machine running Outlook 2013 & there are no others.

Assuming imap downloads by default to the inbox:

- when I backup the .pst, do I really need to backup the .ost if no other apps such as calendar are being connected?

What is benefitted from sav

View Replies


Solved: Outlook Recent Versions - Turning Off Default Pics
Category : Business
Solved: Outlook Recent Versions - Turning Off Default Pics
  In 2013 and other versions, is there a way to turn off the default photos that identify the senders/receivers that also appear among the contacts?

That spot it occupies on the inbox, upper view, perpetually dominates and clogs what needs to be read. You always have to scroll down further... typically a grey silhouette

View Replies


Timer controlled by combo box
Category : Business
Timer controlled by combo box
  1 Attachment(s) Greetings. I am trying to design a combo box based timer in access using vba. My combo box has 0-12 values list where
0 indicates timer is deactivated
1 indicates timer is activated and start time for it is recorded in text box for stage 1

On selecting 2, time interval between stage 1 and 2 will be recorded in text b

View Replies


Word 2010 Macro - Iterative Generator
Category : Business
Word 2010 Macro - Iterative Generator
  I am trying to write a Macro thath will generate a list of all possible combinations of letters. Was thinking about using ASCII but not sure where to start and can't find a thread or existing snippit that I can understand well enough to modify.

I want a list of strings five characters long that accounts for all possible combinations of 26

View Replies


Solved: Access 2007 Record Source - Form gone blank
Category : Business
Solved: Access 2007 Record Source - Form gone blank
  1 Attachment(s) Hi All,


I created a form that uses data from multiple tables. Recently I changed the placement of some of the data - I moved onto a new table. It resulted in my form going blank. I have spent the last few hours scouring the internet and found a few bugs, however my form is still malfunctioning!

View Replies


Solved: Selling Office Home and Student 2010?
Category : Business
Solved: Selling Office Home and Student 2010?
  Can anyone tell me if it is legal to sell an "Office Home and Student 2010 1 User 1 PC" if it has been removed from the PC it was purchased for? We bought it a couple years ago for our granddaughter to use at college. She recently purchased an Apple laptop and couldn't use the version of Office we had, so had to get the Apple ver

View Replies


Solved: Excel appears to calculate incorrectly.
Category : Business
Solved: Excel appears to calculate incorrectly.
  I am using an Excel spreadsheet to keep a simple record of my bank account - i.e debit, credit and balance in three separate columns. Within the same spreadsheet I am using an 'if, then, else' condition comparing two numbers to determine certain information I want to appear in other cells using the 'balance' figure as part of this condit

View Replies


Slow loading PDFs, how to reduce the quality?
Category : Business
Slow loading PDFs, how to reduce the quality?
  Hi,

I'd like to know how to reduce the quality from PDF files.
I have some PDFs here from Openlibrary, they are high quality and the textlayer is loading very slow with switching each page.(up to 5sec to load one page fully, sometimes even longer) pretty annoying when you are searching something in a book. First comes the backg

View Replies


Outlook 2013 - restoring from .pst & closing Outlook
Category : Business
Outlook 2013 - restoring from .pst & closing Outlook
  In various places it says to close down Outlook 2013 prior to restoring from a .pst. To simply copy and paste the .pst file into the proper location which is often listed as an email address.

Why is this, and does restoring in this way really apply when restoring Outlook 2013 from earlier versions of Outlook?

I

View Replies


Outlook 2013 - Way to Import Email Accounts
Category : Business
Outlook 2013 - Way to Import Email Accounts
  Having .iaf type accounts from former Outlook (2000) and Outlook Express, is there a way to import these into Outlook 2013 rather than manually keying them on a restore?

added:
- From what I've been gathering, this cannot be done. That signatures have to be manually recreated. This right? Even when restoring Outlook 2013 to Out

View Replies


Outlook 2013 - Organizing Multiple Accounts for Backup
Category : Business
Outlook 2013 - Organizing Multiple Accounts for Backup
  Under account settings > Add

For multiple accounts, I'm trying to understand if the data for each account is held separately.

My main concern is to have a single backup location, not 10 or 12 that represent all of my email accounts.

I know you can create another account, like "My Personal Fol

View Replies


Access 2010 selecting data from query based on two different sets of criteria
Category : Business
Access 2010 selecting data from query based on two different sets of criteria
  I need to get all the records for two different criteria

ReqDate_Fld between [Report Start Date] and [Report End Date]

and

RetDate_Fld Between the same dates above

putting it in the query twice doesn't work.

The RetDate_Fld can include records where the reques

View Replies


Solved: Access query report query paramater use the param
Category : Business
Solved: Access query report query paramater use the param
  I've got a lending table in which we lend items out, now they can be loan or permanent.

I can run a report with the query parameter on the ReqDate_Fld criteria Between [Report Start Date] And [Report End Date]

The report prints and counts everything borrowed.

Now I want to add more records to the re

View Replies


Solved: Excel Conditional Formatting question- simple
Category : Business
Solved: Excel Conditional Formatting question- simple
  I have applied conditional formatting to a column of cells to highlight the cell red when the date contained in it is > 180 days. The formula applied to all of the cells is =TODAY()-180. Works perfect, however, there are cells with no values (dates) entered yet and they are also highlighted.

Ideally I'd like the cells w

View Replies


Solved: MS Outlook Contacts and Address Book.
Category : Business
Solved: MS Outlook Contacts and Address Book.
  I have worked diligently to import outlook .pst file/s to a new Outlook installation (Outlook 2003 on Windows 7). All contacts, emails and folders are shown correctly.

However, when I am in the inbox and click on "New" to create a new email message, then click on "To" to select the intended recipient, no contact

View Replies


Solved: ISO help with an Excel formula
Category : Business
Solved: ISO help with an Excel formula
  Hi. I need help with the following formula:

=PRODUCT($F$6,G15)

Where F6 is a set value and G... is a series of numbers I'm updating every so often. The problem is that if I paste that formula in several cells, they are filled up with the F6 value. Is there a way to have those cells empty if the G... value is empty?

Tha

View Replies


Solved: delete duplicates within a row; column by column
Category : Business
Solved: delete duplicates within a row; column by column
  1 Attachment(s) Hi everyone,


I'm looking to automate deleting duplicates column by column within each row. For example, in the attached example, on row 590, I'd want to delete duplicates of '1225 Whthrs Mrcvl Rd Ste 206,Hamilton,NJ,08619'. In addition, I'd want this automation to process the entire worksheet.

View Replies



2012 / 2017 Copyrights BigHow , All Rights Reserved .