Used to be able to publish and subscribe...

[nicole]

In an earlier version of Excel, I was able to publish a spreadsheet
and then subscribe to it from Adobe Illustrator. Then when I make
changes to the spreadsheet, it would update the information
automatically in Illustrator.

Short of taking screen shots or saving as PDFs (which won't update
automatically), does anyone know how I can do this now, and keep the
Excel formatting intact? I tried the tab-delimited format, but it
doesn't keep any of the columns.

Thanks in advance,
Nikki

 

[Jim Gordon MVP]

Hi Nicole,

Publish and subscribe is gone.

You don't say why it is that you want to create PDFs, but there may be a
new feature that you can use in your workflow.

Perhaps you can just as easily distribute web pages.

Try this:
In Excel use File > Save As Web Page
Click the Automate button in the Save As dialog box
Choose the option to update the web page every time you save the workbook.

Now all you have to do is distribute the htm file. As a bonus it will
probably be smaller than any PDF, and it won't require the recipient to
have Adobe Reader installed.

If your workbook has additional items in besides text and formulas, make
a new folder when Saving as a Web Page. Then drop the folder onto the
Stuffit DropStuff icon and distribute the stuffed folder. Use DropZip
for Windows users (compression is not as good, though).

-Jim