Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Lotus -> Excel : @roundup command

Posted on 1998-07-28
3
Medium Priority
?
657 Views
Last Modified: 2006-11-17
I have changed a number of .wk4 files to .xls (XL97) format for use at work.  However the Lotus files use the @roundup and @rounddown command.  The new Excel file did not convert these it simply pasted the values in.

However the wizard reported a successful conversion.  I know equivalent commands exist in XL97, can I get the command to work on conversion.

The files are 12meg each and I do not really want to input all the roundup & round down fuctions again, it could take a couple of days.
0
Comment
Question by:DaveF111597
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 3

Expert Comment

by:shalbe
ID: 1612953
DaveF,

Have you tried opening a Lotus file in Excel and then saving it as an Excel workbook manually instead of using the Wizard.

If it works that way and there are a lot of files, I could write a macro that would process a batch of files (I think).

Let me know if it works manually or not.

Steve
0
 

Author Comment

by:DaveF111597
ID: 1612954
Shalbe

Unfortunately I have already tried this, as soon as you open the file in Excel the roundup & rounddown formulas are replaced with values.  An error message is displayed as the file is opened, to the effect that 898 cells could not be processed. (I assume these are the roundup / rounddown cells)

Cheers
Dave
0
 
LVL 3

Accepted Solution

by:
shalbe earned 400 total points
ID: 1612955
Dave,

Go to the following URL titled "XL: Formulas Failed to Convert Error Opening WK4 File" :

     http://support.microsoft.com/support/kb/ARTICLES/Q123/2/61.asp?PR=EXL&T1=7d&FR=0&A=T&T=B&S=T&


There is a wk4 file converter available that should solve your problem. You can get it from a link on that page.

I'm pretty sure this will solve your problem.

Let me know how it goes.

Steve

Steve
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

661 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question