Making a sheet that is universal for different workbooks

flixtan

New Member
Joined
May 31, 2012
Messages
8
Hey I have a problem again =( such an Excel noob I am!!!

Basically there are about 100 roster workbooks. They are for individual store to use.
So I've created a new sheet using one of the store's file as an example.
The sheet is fairly complicated with reference to other sheets INSIDE individual workbooks.

Then I copied the skeleton of the sheet with only the pointers to the sheets that is used, by replacing the file name reference with nothing, to another workbook that I use to roll out the sheets to the other stores.

My problem is now that when I copied over the sheet to the workbook, the cell does not refresh by itself, so the value of the sheets is still #REF. But when I go on that cell, press F2 then enter, the value is shown nicely.
I'm just wondering is there any way I can do the above without having to do that for 34 rows x IM columns!!

Sorry if I'm not making any sense, but any help is greatly appreciated!!! =D:laugh:
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Welcome to the Board!

Try Data-->Edit Links and point the workbook back to itself with the Change Link option.

But if you're using Excel for multiple inputs from different locations you might want to consider using Access, as it's better suited.

HTH,
 
Upvote 0

Forum statistics

Threads
1,226,719
Messages
6,192,667
Members
453,743
Latest member
ntguy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top