Error -- Versions of Excel??

J

jwr

I have a worksheet that is linked to a worksheet in another workbook. I can
edit the links on the dependent worksheet by checking the box that says
"don't ask if you want to update and don't update." I then email that page
to others. Some of the recipients are asked the question - "Do you want to
update?" and others are not -- which is what I am wanting.

Why is this not consistent? My operating system is XP Pro, Excel 2002; some
of the recipients are XP or Windows 2000; some excel 97 and some excel 2000.
Does the operating system make a difference when simply receiving a
worksheet? I would think the answer is no since I am setting the parameters
for the worksheet.

Is this something that I can avoid? I want the end-user to be able to
simply open the attachment without any questions.

Thanks,
JR
 
D

Dave Peterson

This option under Edit|Links|startup prompt was added in xl2002.

So the people who are running xl2k and below don't get the benefit of your
setting.

They are governed by their choice:

Tools|Options|Edit tab
ask to update automatic links

If they have that checked, then they'll get prompted. If they leave it
unchecked, the links will be refreshed (or at least attempted to be refreshed).
 
J

jwr

I think you said what I had found, but I would like to rephrase my question
please.

I am emailing from my computer a link that I had set to "no question, no
update." If they are not on excel 2002 or 2003, their computer disregards
this -- even though it was sent to them with no update?

I was understanding that if the version was excel 2000 and older (1997), the
option was not there to select whether or not it was updated. There was no
choice. It always asked about updating. BUT if the worksheet was sent
without updates selected, it would receive okay.

If my choice of no updates does not govern receiving the worksheet on older
versions of excel, is there a way to avoid that question?

Thanks you for your time.
 
D

Dave Peterson

In xl2k and earlier, your choice doesn't even get seen by excel--it doesn't know
that there is even an option.

The only way I know to avoid the question is to send two workbooks--one that
opens the workbook with those links in the manner that you want. Both workbooks
would have to be stored in the same folder (to make the macro easier).

But then you have to train the users to save both email attachments to the same
folder and to open that "Helper" workbook first.

I don't know of way to make this simpler.
 
J

jwr

That makes sense.

My information is first created in access and then analyzed with Microsoft
excel. I then linked that data to the worksheet I am needing to send.

Since I was having that problem, I tried this:

I just attempted to get external data in excel using my access database. I
selected my query to import, but get statement -- too many parameters - or
expected 4 parameters. I get this message even if I have no parameters set
in my query.

Perhaps there is no way to do what I am wanting.
 
D

Dave Peterson

I don't know enough about Access or Queries to help.

But if you save a copy with these things converted to values and send that,
would it be sufficient?
That makes sense.

My information is first created in access and then analyzed with Microsoft
excel. I then linked that data to the worksheet I am needing to send.

Since I was having that problem, I tried this:

I just attempted to get external data in excel using my access database. I
selected my query to import, but get statement -- too many parameters - or
expected 4 parameters. I get this message even if I have no parameters set
in my query.

Perhaps there is no way to do what I am wanting.
Click to expand...
 
D

Dave Peterson

Formats like color and borders?

How did you convert to values?

Just edit|copy, edit|paste special|values doesn't usually affect formatting???
the answer is yes; however, I have tried that and my format gets lost.
Click to expand...
 
D

Dave Peterson

Kind of...

But I should have been more specific.

Open your workbook
file|SaveAs a new name (don't damage the original!)
Now select the cells
edit|copy
edit|paste special|values
right on top of those same cells.

The formulas will be replaced by their values and the formatting will stay.

Do this for each worksheet.

Then save it once more.
Edit/copy; (opened blank workbook) edit/paste special/values

I copied the entire worksheet - not each cell individually. Cells that had
background color, bold type, merged cells, etc. - format was lost. I have
all of the information, just not in the original format. Did I do this
correctly?
Click to expand...
 
Top