Re: [libreoffice-users] Clean old things from Excel

Doug McNutt wrote:
> I have managed to move my finance workbook from a CY 2001 version of
> Excel to libre-office-calc.
>
> I had a lot to learn and I'm still frustrated when I want to insert a
> few lines of entries from the bank. It's a pain having to do a separate
> entry of the number of lines and then paste in contents. But..
>
> Every time I start up the workbook I get a complaint that I'm using
> macros and references to another file which is probably where I stored
> macro-like commands that I wrote for Excel on the Mac. They used the
> Macintosh Programmer's Workshop, MPW, development tools.
>
> I'd like to get rid of the mouse and keystrokes required to startup. I
> just say "no" to both but there must be a better way. For those
> references there is probably a reference in the 20 worksheets but Mr.
> Calc isn't telling me where they are.

Depending how the data is linked, Edit > Links... might help.

> As for the macros I'd like to
> discard them and rewrite those I really need using your command
> structure. But where are they so I can killem?

Is the document saved as .ods or .xls? Saving as .ods might get rid of 
the Excel macros. If that doesn't help, try Tools > Macros > Organise 
Macros > LibreOffice Basic > Organiser...; see of there's anything under 
the spreadsheet in any of the tabs there.

--
Mark.


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted