 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Calendaring / July 2006importing an Excel document to Outlook Calendar
I've named a range on the Excel document, but when I try to import it gives me an error message that tells me I need to name a range. Try this, create an item in Outlook's Calendar - export it to Excel and compare the documents. Massage yours to match the Outlook format and try it again.  SignatureMilly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account will be deleted without reading. After furious head scratching, Dawn asked: | I've named a range on the Excel document, but when I try to import it | gives me an error message that tells me I need to name a range. > Try this, create an item in Outlook's Calendar - export it to Excel and > compare the documents. Massage yours to match the Outlook format and try it [quoted text clipped - 4 lines] > > After much massaging, it did work. Thank you so much. Hopefully, I'll remember everything I did the next time I have to do it! Thanks, again! Glad it worked for you! SignatureMilly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account will be deleted without reading. After furious head scratching, Dawn asked: || Try this, create an item in Outlook's Calendar - export it to Excel || and [quoted text clipped - 17 lines] || I'll remember everything I did the next time I have to do it! || Thanks, again! I've read the solutions, but i don't get it. where do i put the named ranges in the excel page? please help? > Try this, create an item in Outlook's Calendar - export it to Excel and > compare the documents. Massage yours to match the Outlook format and try it > again. > > | I've named a range on the Excel document, but when I try to import it > | gives me an error message that tells me I need to name a range. If you have exported Outlook items to Excel, and have your Excel spreadsheet open, what about comparing the two items is hard to understand? What exactly are you asking? Look at the two of them, compare the data layout, and then make yours like the one from Outlook. SignatureMilly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account will be deleted without reading. After furious head scratching, SANMAN07 asked: | I've read the solutions, but i don't get it. where do i put the named | ranges in the excel page? please help? [quoted text clipped - 14 lines] ||| I've named a range on the Excel document, but when I try to import ||| it gives me an error message that tells me I need to name a range. I am importing from Excel to calendar and it is only picking up the first month of information and no more. I have seen a date range box come up before but now I don't. > I've named a range on the Excel document, but when I try to import it gives > me an error message that tells me I need to name a range. Make sure your named range in Excel covers all the data you want to import. SignatureSue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx >I am importing from Excel to calendar and it is only picking up the first > month of information and no more. I have seen a date range box come up > before but now I don't. > >> I've named a range on the Excel document, but when I try to import it gives >> me an error message that tells me I need to name a range.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.