Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

Geek Culture / Excel Problems. Taking a SIngle Page from a Workbook

Author
Message
soapyfish
21
Years of Service
User Offline
Joined: 24th Oct 2003
Location: Yorkshire, England
Posted: 22nd May 2006 18:50
Hi all,
I've got a bit of a problem with an excel workbook and wondered if anyone could help. At the moment the workbook is fine but I only want to send one page to people. If I copy and paste that page into a new excel document all the values go belly up because the formulas are linked between the pages. If anyone knows of a way to export just a single page but keep all the values intact I'd be extremely grateful. Thanks in advance.

p.s. I've tried googling it but with no luck.

<º))))><.·´¯`·.Here's to the crazy ones¸.·´¯`·.¸><((((º>
Toby Quan
21
Years of Service
User Offline
Joined: 16th Oct 2003
Location: U S A
Posted: 22nd May 2006 18:51
Try printing the page as a PDF file with Adobe and just send them the PDF file.

Or try copying and pasting the calculated data to a text file and send them that.
spooky
22
Years of Service
User Offline
Joined: 30th Aug 2002
Location: United Kingdom
Posted: 22nd May 2006 19:00
Select whole sheet and copy, then goto another sheet and 'paste special' and use the 'values' option.

Boo!
soapyfish
21
Years of Service
User Offline
Joined: 24th Oct 2003
Location: Yorkshire, England
Posted: 22nd May 2006 19:28
Thank you.

<º))))><.·´¯`·.Here's to the crazy ones¸.·´¯`·.¸><((((º>

Login to post a reply

Server time is: 2024-11-17 02:34:02
Your offset time is: 2024-11-17 02:34:02