Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

copying excel content


  • Please log in to reply

#1
shlmathew

shlmathew

    New Member

  • Member
  • Pip
  • 3 posts
hi guru's,

i wanted to copy the contents in a spreadsheet as well as 100's of interlinked(attached link -source is different) spread sheets content at the same time !! is it possible or is there any tool available for that ?? microsoft sharepoint we can use for it?

regards
mathew
  • 0

Advertisements


#2
piper

piper

    Retired Staff

  • Retired Staff
  • 2,459 posts
Are you going to "Save As" your workbook or just copy/paste data from the sheet? Are you wanting to copy the data from those links that is displayed in the master sheet or copy the linked workbooks as well? Do all the linked workbooks reside in the same location or are the scattered across a network?

Exactly what are you trying to accomplish?
  • 0

#3
shlmathew

shlmathew

    New Member

  • Topic Starter
  • Member
  • Pip
  • 3 posts
the linked workbooks are in the same location and i wanted to get the contents from each workbook (for eg:- imagine the index of a book and it has various chapters ;if i click on say chapter 1 [this chapter contains pictures 20 pages data etc) like that 10 chapters are there .i want all of them

please help
  • 0

#4
piper

piper

    Retired Staff

  • Retired Staff
  • 2,459 posts
Where are you posting the workbook for access? On the web or a server drive?
  • 0

#5
shlmathew

shlmathew

    New Member

  • Topic Starter
  • Member
  • Pip
  • 3 posts
on the server driver
  • 0

#6
piper

piper

    Retired Staff

  • Retired Staff
  • 2,459 posts
So, all the workbooks are stored in a server folder and users will access/open the main workbook via a shortcut to the main workbook?

Supposing the main workbook and all linked workbooks are in a central location (server folder that is shared for all users), have you tried to access the main workbook from another user workstation? It seems like it should work like any other shared resource.

I'm not familiar with Sharepoint Services, but is the above scenario doesn't work, post back and we'll bump the thread.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP